Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Total no. of application hits Expand / Collapse
Author
Message
Posted Thursday, June 27, 2013 9:52 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 17, 2014 1:58 AM
Points: 866, Visits: 457
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!!
Post #1468241
Posted Thursday, June 27, 2013 10:03 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 13, 2014 4:54 AM
Points: 708, Visits: 3,290
Yogeshwar Phull (6/27/2013)
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!!


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

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
Post #1468244
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse