March 5, 2009 at 3:01 pm
Hi,
I need to gather capacity planning stats on a DB server that is heavily used by 10 .Net Applicatons. All apps are coming from the same web server.
I want daily stats like
1) when is the most busy period is
2) which app take up most resource etc
Can anyone suggest a good way to do this?
Regards,
Michael
March 6, 2009 at 6:42 am
Out of the box, without installing anything else, you can use perfmon to gather performance metrics on the server and set up a server-side trace to capture the performance metrics of the queries. This article [/url]is a high-level introduction that ought to get you started.
"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
March 7, 2009 at 2:48 pm
Thanks Grant, your article is very helpful.
March 7, 2009 at 4:24 pm
I'm glad it helped. Understand though, it really is introductory. You're going to blow past it pretty quick. Come back and post when you have questions on details as you implement stuff. People here will help.
"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 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply