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.
| Author |
Topic |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2010-08-03 : 03:51:00
|
| Hi all anyone has some queries to run on a SQL Server 2000 DB to control performance, locks, and whatever else might find it useful to investigate any locks of various types and slowdowns? Thanks in advance. Luigi |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-08-03 : 04:54:22
|
| You're probably best to run SQL Server Profiler first.Capture RPC:Completed and SQL:Batch Completed in the events and make sure you have TextData, CPU and Reads in the data columns. |
 |
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2010-08-03 : 05:10:37
|
quote:
Originally posted by DaleTurley
You're probably best to run SQL Server Profiler first.Capture RPC:Completed and SQL:Batch Completed in the events and make sure you have TextData, CPU and Reads in the data columns.
Unfortunately I don't have permissions to run the Profiler in the db in production. There are other ways? |
|
|
|
|
|
|
[SS2000] Investigate poor performance