How do I run statistics on MS Sql Server database?
Posted on 2009-05-04
I have a few statistics that I need to figure out and I have never used the MS SQL 'Profiler'. Can someone help me understand how to gather the following stats. I am also under the assumption that I need to use the Profiler to gather this information - please correct me if I'm wrong! :)
avg/max queries per second
avg/max number of rows returned
ave/max number of connections (active)
Also, the purpose of this execise is to help me understand what sort of hardware I should purchase for the amount of bandwidth required on my database server. Are these the stats I really need to know? Please help - newbie here.