SQL 2005 Peformance trace file [server side] - counters - Urgent

Hi

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
PAE

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.

Thanks

Mo
mooriginalAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
0
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
and
Troubleshooting Performance Problems in SQL Server 2005
http://technet.microsoft.com/en-us/library/cc966540.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mooriginalAuthor Commented:
thanks the first link has some basic trace flags and how to setup a server side trace

which i already know how to do

the 2nd link is so huge as to where to start

i was hoping for a more defined list of more than simple and not too open ended
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
They are complaining about performance?
It's that SQL Server the 32 bits or 64 bits version? If it's 32 bits you need to activate AWE so he can use more than 2GB of RAM.
The performance problem is during all day or only happens sometimes? If happens only sometimes then you should look first for long running queries and locks.

Good luck
0
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
2nd link gives you what you need

unless you know what you are fishing for- so we can more specific

--
if you do not know for sure -- start your sql profiler and get sql server trace templates with all preset counters that you can use for your sql side trace : for example :tsql_duration
see more
SQL Server Profiler Templates
http://msdn.microsoft.com/en-us/library/ms190176(v=sql.90).aspx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.