February 8, 2011 at 3:37 pm
Can anyone provide a sql query which gives the amount of DB activity going on ...
1.Create a baseline for the Db activity
2.measuring it against a set baseline
Thanks
February 8, 2011 at 3:54 pm
This should be the information you need.
http://www.brentozar.com/sql/sql-server-performance-tuning/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 9, 2011 at 5:56 am
There isn't a way to write a single query that will gather all the information needed. Like the link to Brent's site shows, you're going to, at a minimum, hit two different tools for information, Performance Monitor and Server Side Trace (don't use the Profiler GUI in your production servers, ever). You'll also find that you need to include dynamic management objects as well. Establishing a baseline is an extended operation. The key point, gather your metrics and keep them. You have to have the data available in order to compare the baseline to the current set of metrics.
If you can get down to Florida in May, I'll be doing a full day on performance tuning, including a couple of hours on setting up performance metrics gathering at SQL Rally[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply