Author |
Topic |
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-02 : 10:11:54
|
What are my options to find heavily accessed DBs on a server? I know I can do this by profiler and some counters. Is there any tool which gives me this information easily? ------------------------I think, therefore I am - Rene Descartes |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 22:43:53
|
Perfmon is free, or third party sql monitoring tools. |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-03 : 09:19:49
|
I need to find the heavily accessed DBs across several servers. I was just wondering, - is there a simple way to achieve this?------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-03 : 09:56:17
|
Profiler will be solution for you or you need to get third party tools to monitor. |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-03 : 10:04:51
|
My concern is – if I use profiler I need to configure it for around 50 servers. That is a tedious job.------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-03 : 10:38:28
|
Thats why you need to get third party tools. |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-03 : 10:40:57
|
What is the name of the third party tool?------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-03 : 11:59:05
|
Don't know. Never came to this issue. |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-03 : 12:06:13
|
I am thinking of using - sys.dm_os_performance_counters.------------------------I think, therefore I am - Rene Descartes |
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-03 : 14:22:59
|
We are using Foglight from Quest. It helped me a lot. I beleive this will resolve your issue as well.ManojMCP, MCTS |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 16:08:04
|
Take look at perfmon counter sqlserver:databases\active transactions and transaction/sec for each db on each server. |
|
|
|