SQL Server activity monitoring

Last Post 08 Aug 2008 05:27 AM by dbandee. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

08 Aug 2008 05:27 AM
Hello all

Our server is pretty busy between 6am and 10 am
Number of jobs are shceduled, ppl run DTS on demand as well as queries, crystal rpts
what i need to do is to record server activity at these times so i can say
X percent of morning activity was scheduled jobs, Y percent was DTS manually kicked off and Z percent was queries

Is it possible to get something like this and how to do it?

Acceptable Use Policy