how to get most queried db in the ms sql db server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » how to get most queried db in the ms sql db...

how to get most queried db in the ms sql db server

Rate Topic

Display Mode

Topic Options

Author

Message

Tripz

Posted Tuesday, October 09, 2012 10:05 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, April 04, 2013 8:20 AM
Points: 33, Visits: 124

Hello All..

My boss asked me to give the list of top 5 most queried database in our db server(Ms Sql Server 2005).

How can I achieve this? Any ideas, suggestions and approach?

Post #1370466

Sean Lange

Posted Tuesday, October 09, 2012 10:24 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:34 PM
Points: 8,592, Visits: 8,233

Tripz (10/9/2012)

Hello All..

My boss asked me to give the list of top 5 most queried database in our db server(Ms Sql Server 2005).

How can I achieve this? Any ideas, suggestions and approach?

What does that even mean? Is your boss looking for the databases that have the most queries executed or the more resource intensive ones? I am guessing he/she want to know the quantity of queries which seems very strange. I wouldn't even begin to have an idea how to count the number of queries executed in a day. You would have to use a trace but the counts will be staggering in a busy system throughout the day.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1370477

Tripz

Posted Tuesday, October 09, 2012 10:33 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, April 04, 2013 8:20 AM
Points: 33, Visits: 124

He wants to know the 'the database which has the most number of queries executed' per day,

to see to which db's are used(quried) more on daily basis by the world.

Post #1370481

Scott D. Jacobson

Posted Tuesday, October 09, 2012 11:03 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:17 PM
Points: 335, Visits: 841

... And that number will tell you what exactly?

Post #1370491

Tripz

Posted Tuesday, October 09, 2012 11:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, April 04, 2013 8:20 AM
Points: 33, Visits: 124

That is out of my scope, I just need to give the information what they were looking for.
I think they were doing some network analysis..

Post #1370497

Sean Lange

Posted Tuesday, October 09, 2012 11:46 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:34 PM
Points: 8,592, Visits: 8,233

Tripz (10/9/2012)

That is out of my scope, I just need to give the information what they were looking for.
I think they were doing some network analysis..

For network analysis the number of queries doesn't actually mean anything. My guess is they are trying to figure out network traffic. Let's say we have one db that has 10 million queries executed per day but the average result set is 20k bytes. On another db we have 300 queries but the this database is full of images or files. You can see that the impact to the network has nothing to do with the number of queries.

I know it is outside your scope but getting an understanding of the requirements and usage of the information shouldn't be. Just getting the top 5 databases with the most queries is not really what the boss is looking for. It isn't always easy to push back but in this case I think you should ask for some clarification about the requirements.

If you just simply have to count queries you need to setup a trace and be prepared to be shocked at the number.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1370515

Ratheesh.K.Nair

Posted Tuesday, October 09, 2012 11:33 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:03 AM
Points: 2,415, Visits: 3,374

He should better ask the application team.

Post #1370683

Tripz

Posted Wednesday, October 10, 2012 10:20 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, April 04, 2013 8:20 AM
Points: 33, Visits: 124

mmm ... I will try to find more details about it and get back to you
Thank you for the supportive details

Post #1371031

lptech

Posted Monday, October 22, 2012 9:48 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 2:23 PM
Points: 96, Visits: 981

If you still need to get this done, one method was mentioned in this week's Database Weekly email:

http://www.sqlservercentral.com/blogs/ctrl-alt-geek/2012/10/17/querying-database-usage/

Post #1375546

« Prev Topic | Next Topic »

Permissions