July 2, 2008 at 12:52 pm
Hi to all.
I have a small doubt.
How we will check the number of hits that an application receives.
In which area we have to check.
we have an internal application. we want to check the number of hits this application receives.our application uses sql server.
Waiting for ur replies
Thanks,
Sandhya
July 2, 2008 at 12:59 pm
Not sure exactly what you mean by "number of hits". If you mean how many queries it sends to the database, you can run a trace to track that. If you mean how many successful queries (how many find a match), you can log that in your select procs. If you mean how many songs it writes that make it to a Top 10 list, I'm not sure how to do that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 2, 2008 at 1:02 pm
select * from master.dbo.sysprocesses
select * from master.sys.sysprocesses
select * from sys.dm_exec_sessions
I am not sure if you applicaiton will show up in the Program_name column.
Try Filter by username,hostname,dbid etc.
Maninder
www.dbanation.com
July 3, 2008 at 8:36 am
Check the Activity Monitor
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply