April 24, 2017 at 11:10 am
Hi,
I would like to know performance metrics related to only one database , not all databases in the instance.
Can that be achieved using perfmon or data collector?
I get the reports with all the databases activities.
How can I restrict the reports to a single database?
April 24, 2017 at 1:35 pm
To get the use of a single database, you need to target data collection to only capture information about the database. The built-in, automatic collections that you see are server specific. I'd suggest looking to extended events to identify a particular database and start capturing metrics for it.
"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
April 24, 2017 at 2:06 pm
Thanks, will check on extended events and configuration.
Do you recommend any blog post or article for configuring these?
April 24, 2017 at 3:06 pm
If you do a web search for Extended Events, the first or second link is usually the "Getting Started" documentation from Microsoft. That's the best way to get 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
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply