My Database team is working on, to find the database traffic on the server. The database is heavily used by the Online appllication and it is 24/7. We would like to see when the database is heavily loaded and see if there are any processes blocking each other which results in slower performance. One option which came to my mind is setting up a server side trace and capture rpc complete and sql batch complete events along with other events. So we decided to run the trace for 1 week during the first week of the month and 1 week during middle of the month and last week of the month because we are very sure that this is the time where the system is heavily loaded.
During this preriod of time i happen to read one article from technet. With the help of this article you can find the follwwing information:
- Determine who's connected to your SQL Server
- Dealing with blocked processes
- Performance killers
- Clues to SQL Server performance problems
Get A Traffic Report: Analyze Your Database Usage With System Tables
No comments:
Post a Comment