Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  SQL profiler centrally administrate

Author  Topic  songqh Starting Member 9 Posts Posted - 2001-08-13 : 21:04:32 Question: You have SQL 7.0 on Win98 machines in branch offices and in the corporate you have SQL 7.0 on winNT server. Branch offices report slow performanece. Database Admin is in the corporate office. How should the profiler be configured in the branch offices so that they can be centralley collected in the corporate office by the database Admin? A.Use SQL Profiler Xtended sp and send them to NT App Log in the central office. B.Use SQL Profiler pr.Xtended sp and send them to centralized table in the corp. C.Use xp_sendmail procedure to send the statistics thru e-mail to the database Admin. D.Use operation system commands to build a file etc., and send them to the corp office. which one is correct answer? why ?