patternMinor
what is hitting your db?
Viewed 0 times
hittingyourwhat
Problem
What is a quick way of finding out what is hitting your database especially when the log files are going crazy. SQL profiler? If so, how?
Solution
Can you add more details? I hope you are using SQL Server and which version + edition? Are your log files are filling up? Are you taking transaction log backups regularly? What are the result of the below?
You can use profiler to trace all the current activity but on a busy system, it can hurt the performance? Do you know how to do server side trace? You can try that below. But you need to share more details to get good responses.
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
select name, log_reuse_wait_desc from sys.databases
DBCC OPENTRAN()You can use profiler to trace all the current activity but on a busy system, it can hurt the performance? Do you know how to do server side trace? You can try that below. But you need to share more details to get good responses.
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
Code Snippets
select name, log_reuse_wait_desc from sys.databases
DBCC OPENTRAN()Context
StackExchange Database Administrators Q#2137, answer score: 4
Revisions (0)
No revisions yet.