Re: Need SQL Profiler advice
From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 05/18/04
- Next message: Utada P.W. SIU: "[QUESTION]"
- Previous message: Sreedhar Kaluva: "setupsql.exe hangs. Cannot Install SQL server 2K"
- In reply to: rooster575: "Need SQL Profiler advice"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 May 2004 21:28:14 -0400
You might want to have a look at these:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
-- Andrew J. Kelly SQL MVP "rooster575" <rooster575@hotmail.com> wrote in message news:OGrZlqGPEHA.1512@TK2MSFTNGP10.phx.gbl... > I'm interested in finding problem areas [regarding performance] in my > database. > > During mid-to-high level use, I am planning to run the Profiler to trace any > inefficiencies, but there are so many different categories to choose from. > > Can anyone suggest a few categories that will help me find bottlenecks such > as table scans, re-compilation of stored procedures, etc.? [or anything else > I've left out] > > Any help is greatly appreciated. > Thanks. > >
- Next message: Utada P.W. SIU: "[QUESTION]"
- Previous message: Sreedhar Kaluva: "setupsql.exe hangs. Cannot Install SQL server 2K"
- In reply to: rooster575: "Need SQL Profiler advice"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
