Wanted a profile on SQL SERVER Profiler 1

[Warnie]

I wanted information on how I can use the SQL SERVER profiler as an effective tool to optimize my server performance? Also it would be helpful if there are any pointers on using the performance monitor of SQL server effectively.

Thanks in advance,
Nidhi

 

[tlbroadbent]

Check thread183-129404 for a link to an article on performance tuning. The author discusses using Profiler/Traces.

There are four articles at SQL Server Performance.com that discuss using Performance monitor.

http://www.sql-server-performance.com/performance_monitoring_tutor_part1.asp

http://www.sql-server-performance.com/performance_monitoring_tutor_part2.asp

http://www.sql-server-performance.com/performance_monitoring_tutor_part3.asp

http://www.sql-server-performance.com/performance_monitoring_tutor_part4.asp

You'll also want to check out the following articles.

How to Take Advantage of SQL Server 2000 Performance Tuning Tools

http://www.sql-server-performance.com/sql_2000_tools_tutorial.asp

Performance Tuning for SQL Server Developers

http://www.sql-server-performance.com/developers_tuning_tutorial.asp

Use SET STATISTICS IO and SET STATISTICS TIME to Help Tune Your SQL Server Queries

http://www.sql-server-performance.com/statistics_io_time.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Warnie]

Thanks Terry for the pointers. They were all helpful in making understand about SQL SERVER performance by a long way. But I still want a small clarification from you. The articles say that on a NT workstation, you can monitor the performance of several servers. I am unable to comprehend how to select the server for monitoring. If you can tell me which menu should I be looking at, it would be a great help.
Thanks in advance....

 

[tlbroadbent]

When you use Performance Monitor, you can add objects and counters to the monitor. When you invoke the Add to Chart or Add to Log dialogs, the computer name is displayed on the first line. You can type in a server name (i.e., \\server1) or click on the box on the right of the name to select from a list of network servers.

After selecting the server, select one or more counters. Click on the Add button. You can add multiple counters per server and multiple servers per chart or log. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Warnie]

Thanks Terry for the pointers. I am now able to fully appraise my SQL SERVER. Can you provide me some links for making use of the PROFILER as well?

 

[tlbroadbent]

In addition to the four articles on Profiler at the SQL Server Performance website, there is good info in SQL BOL and at the Microsoft website.

Monitoring with SQL Profiler

http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_6koi.asp

Microsoft SQL Server 7.0 Performance Tuning Guide

http://msdn.microsoft.com/library/en-us/dnsql7/html/msdn_sql7perftune.asp

SQL Server Magazine's Website currently has several articles focusing on Profiler.

http://www.sqlmag.com/

Scheduling SQL Server Profiler Trace Using Extended Stored Procedures

http://www.sqlservercentral.com/col...gsqlserverprofilertraceusingextendedstore.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.