June 27, 2013 at 9:52 am
Hello
Is there an easy way of calcluating how many times an application hits SQL server on daily basis. I was thinking of using SQL server profiler for counting how many times it logs in by its service account (using audit logon event) and that would be equivalent to no. of times application connects SQL server. Is there any other easy way. I have SQL server 2008 SP1 CU2 enterprise edition x64.
Thanks in advance!!
June 27, 2013 at 10:03 am
Yogeshwar Phull (6/27/2013)
HelloIs there an easy way of calcluating how many times an application hits SQL server on daily basis. I was thinking of using SQL server profiler for counting how many times it logs in by its service account (using audit logon event) and that would be equivalent to no. of times application connects SQL server. Is there any other easy way. I have SQL server 2008 SP1 CU2 enterprise edition x64.
Thanks in advance!!
Another way: http://www.littlekendra.com/2011/02/01/whoisactive/
Not as easy (initially when you're getting use to sp_whisActive) as using profiler but well worth getting to know how to use sp_whoisActive I can't praise it enough.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply