SQLServerCentral.com / SQL Server 2008 - General / SQL Server 2008 / Total no. of application hits / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 09:21:47 GMT20RE: Total no. of application hitshttp://www.sqlservercentral.com/Forums/Topic1468241-391-1.aspx[quote][b]Yogeshwar Phull (6/27/2013)[/b][hr]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!![/quote]Another way: [url]http://www.littlekendra.com/2011/02/01/whoisactive/[/url]Not as easy (initially when you're getting use to sp_whisActive) as using profiler but well worth getting to know how to use [b]sp_whoisActive[/b] I can't praise it enough.Thu, 27 Jun 2013 10:03:48 GMTAbu DinaTotal no. of application hitshttp://www.sqlservercentral.com/Forums/Topic1468241-391-1.aspxHelloIs 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!!Thu, 27 Jun 2013 09:52:07 GMTYogeshwar Phull