SQL 2005 Peformance trace file [server side] - counters - Urgent
Posted on 2012-03-21
I have a server that user wants to be monitiored
Id like a complete list of the most pertinent counters or recommendations needed in an effective trace.
The trace will be running for a day while the server is used.
The server has the following:
Windows 2003 Ent SVP 2
SQL Server 2005
16 GB's memory
Intel Xeon x7350 @2.9 ghz
Can someone please provide complete list trace counters
or counters as sql code for a server side trace
or a trc template file.
Any monitoring to track peformance or bottlenecks...considering the spec of the server.
It would be good if it could include some windows specific counters in the sql trace but not essential as server team is doing a set of these too..
The trace will be run as server side.
This is urgent please for thursday end of business.. GMT.