http://sqlserver2000.databases.aspfaq.
com/how-do-i-monitor-sql-server-
performance.html
Following MS Articles and lot more defined in the above URL also would help you�
HOW TO: Determine Proper SQL Server Configuration Settings
http://support.microsoft.com/default.aspx/kb/319942
HOW TO: Troubleshoot Application Performance with SQL Server
http://support.microsoft.com/default.aspx/kb/224587
INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/default.aspx/kb/254321
Good article about PAE and AWE
If we are using the more than 4GB of memory on SQL db server on x86 architecture,
we can enable PAE and AWE switches on server to make use of maximum available
memory.
http://www.sql-server-performance.com/awe_memory.asp
Performance References:
Inside SQL Server 2000 by Kalen Delaney http://www.insidesqlserver.com
<blocked::blocked::http://www.insidesqlserver.com>
The Guru's Guides (Transact-SQL, Architecture and Internals, Stored Procedures and
XML) http://www.khen.com/books.htm
<blocked::blocked::http://www.khen.com/books.htm>
224587 INF: Troubleshooting Application Performance with SQL Server
http://support.microsoft.com/?id=224587
<blocked::blocked::http://support.microsoft.com/?id=224587>
243586 INF: Troubleshooting Stored Procedure Recompilation
http://support.microsoft.com/?id=243586
<blocked::blocked::http://support.microsoft.com/?id=243586>
298475 INF: Information Required to Successfully Troubleshoot Application
http://support.microsoft.com/?id=298475
<blocked::blocked::http://support.microsoft.com/?id=298475> " \o
"http://support.microsoft.com/?id=298475http://support.microsoft.com/?id=298475
<blocked::blocked::http://support.microsoft.com/?
id=298475http://support.microsoft.com/?id=298475>
175658 How To Gather Information for Effective Troubleshooting of Performance
http://support.microsoft.com/?id=175658
<blocked::blocked::http://support.microsoft.com/?id=175658>
319942 HOW TO: Determine Proper SQL Server Configuration Settings
http://support.microsoft.com/?id=319942
<blocked::blocked::http://support.microsoft.com/?id=319942>
297864 INF: Performance Considerations for an Upgrade from SQL Server 6.5
http://support.microsoft.com/?id=297864
<blocked::blocked::http://support.microsoft.com/?id=297864>
314648 INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO
http://support.microsoft.com/?id=314648
<blocked::blocked::http://support.microsoft.com/?id=314648>
311826 INF: Index Tuning Wizard Best Practices http://support.microsoft.com/?
id=311826 <blocked::blocked::http://support.microsoft.com/?id=311826>
Index Tuning Wizard 2000, http://msdn.microsoft.com/library/techart/itwforsql.htm
<blocked::blocked::http://msdn.microsoft.com/library/techart/itwforsql.htm>
Index Tuning Wizard 7.0,
http://msdn.microsoft.com/library/techart/msdn_sqlindex.htm
<blocked::blocked::http://msdn.microsoft.com/library/techart/msdn_sqlindex.htm>
Troubleshooting the Index Tuning Wizard,
http://msdn.microsoft.com/library/psdk/sql/tr_servtools_48ro.htm
<blocked::blocked::http://msdn.microsoft.com/library/psdk/sql/tr_servtools_48ro.htm
>
195565 INF: How SQL Server 7.0 and SQL Server 2000 Autostats Work
http://support.microsoft.com/?id=195565
<blocked::blocked::http://support.microsoft.com/?id=195565>
197297 INF: Comparison of Join Techniques http://support.microsoft.com/?id=197297
<blocked::blocked::http://support.microsoft.com/?id=197297>
324692 Support WebCast: How to Collect and Analyze Performance Data in
http://support.microsoft.com/?id=324692
<blocked::blocked::http://support.microsoft.com/?id=324692>
325263 Support WebCast: SQL Server 2000 Profiler: What's New and How to
http://support.microsoft.com/?id=325263
<blocked::blocked::http://support.microsoft.com/?id=325263>
815337 Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans in
http://support.microsoft.com/?id=815337
<blocked::blocked::http://support.microsoft.com/?id=815337>
283886 HOW TO: View SQL Server 2000 Performance Data http://support.microsoft.com/?
id=283886 <blocked::blocked::http://support.microsoft.com/?id=283886>
139609 PerfMon: High Number of Pages/Sec Not Necessarily Low Memory
http://support.microsoft.com/?id=139609
<blocked::blocked::http://support.microsoft.com/?id=139609>
268343 Umdhtools.exe: How to Use Umdh.exe to Find Memory Leaks
http://support.microsoft.com/?id=268343
<blocked::blocked::http://support.microsoft.com/?id=268343>
286350 HOWTO: Use Autodump+ to Troubleshoot "Hangs" and "Crashes"
http://support.microsoft.com/?id=286350
<blocked::blocked::http://support.microsoft.com/?id=286350>
316365 INFO: ROADMAP for How to Use the .NET Performance Counters
http://support.microsoft.com/?id=316365
<blocked::blocked::http://support.microsoft.com/?id=316365>
150934 How to Create a Performance Monitor Log for NT Troubleshooting
http://support.microsoft.com/?id=150934
<blocked::blocked::http://support.microsoft.com/?id=150934> " \o
"http://support.microsoft.com/?id=150934http://support.microsoft.com/?id=150934
<blocked::blocked::http://support.microsoft.com/?
id=150934http://support.microsoft.com/?id=150934>
130926 Using Performance Monitor to Identify a Pool Leak
http://support.microsoft.com/?id=130926
<blocked::blocked::http://support.microsoft.com/?id=130926>
146005 Optimizing Windows NT for Performance http://support.microsoft.com/?
id=146005 <blocked::blocked::http://support.microsoft.com/?id=146005>
248345 How to Create a Log Using System Monitor in Windows 2000
http://support.microsoft.com/?id=248345
<blocked::blocked::http://support.microsoft.com/?id=248345>
275685 INF: Importing Performance Monitor Logs into SQL Server
http://support.microsoft.com/?id=275685 <blocked::http://support.microsoft.com/?
id=275685>
Blocking/Deadlocks
224453 INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
http://support.microsoft.com/?id=224453
<blocked::blocked::http://support.microsoft.com/?id=224453>
832524 SQL Server technical bulletin - How to resolve deadlocks
http://support.microsoft.com/?id=832524
<blocked::blocked::http://support.microsoft.com/?id=832524>
263889 INF: SQL Blocking Due to [[COMPILE]] Locks http://support.microsoft.com/?
id=263889 <blocked::blocked::http://support.microsoft.com/?id=263889>
75722 INF: Reducing Lock Contention in SQL Server http://support.microsoft.com/?
id=75722 <blocked::blocked::http://support.microsoft.com/?id=75722>
323630 INF: Resolving Blocking Problems That Are Caused by Lock Escalation in
http://support.microsoft.com/?id=323630
<blocked::blocked::http://support.microsoft.com/?id=323630>
295108 INF: Incomplete Transaction May Hold Large Number of Locks and Cause
http://support.microsoft.com/?id=295108
<blocked::blocked::http://support.microsoft.com/?id=295108>
317375 INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server
http://support.microsoft.com/?id=317375
<blocked::blocked::http://support.microsoft.com/?id=317375>
324885 Support WebCast: Microsoft SQL Server: Rapid Blocker Script Analysis
http://support.microsoft.com/?id=324885
<blocked::blocked::http://support.microsoft.com/?id=324885>
215520 INFO: COM+ and MTS Always Use SERIALIZABLE Transaction Isolation Level
http://support.microsoft.com/?id=215520
<blocked::blocked::http://support.microsoft.com/?id=215520>
48712 INF: Handling Timeouts Correctly in DB-Library http://support.microsoft.com/?
id=48712 <blocked::http://support.microsoft.com/?id=48712>
