Is there a native tool (profile,trace,performance) feature I can use to determine the amount of transactions that occur throughout the day? Or is there a system table that keeps track of this(would be preferable .. less strain on the system)?
I assume figuring out the transaction in a certain period will enable me to calculate the busiest periods...I need to know the busiest period of the day...how do I do this without putting an additional strain on the server (can I use a different machine other than the server to save a trace) ...I need to determine strain on (processor,memory, and disk).
I also need to get a count on the largest number of users (running transactions) on the server simultaneously.
Any help/advice would be deeply appreciated
You need to run profiler for this purpose... there is no system table as such which stores all the transactions... What u can do is.. run profiler and store it as table and query the table as u want... Be sure what all are the data u need to capture... Profiler can cause performance degradation.... Capture only the required data by selecting proper column filter and event
Madhu
|||
Running PROFILER on full day is not a good thing if you still have performance problems, lately.
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm - automating such trace.
Refer:
select count(*) as TotalConnections from master..sysprocesses
go
select substring(db_name(dbid),1,30) as DB_name ,count(*) as Connection
from master..sysprocesses
group by substring(db_name(dbid),1,30)
