Transcript Jean Joseph - Professional Association for SQL Server

Jean Joseph
DBA\DEVELOPER
[email protected]
How to Identify Database
Performance Issues
Reports are running Slow
SQL Server is typically affected by the following bottlenecks:
1.
2.
3.
4.
5.
6.
7.
8.
Locking, blocking, or deadlocking
statistics
indexes/missing indexes/Duplicate index/Fragmentation
parameter sniffing
CPU
Memory
File I/O
Network
Demo
APPLICATION IS DOWN
WHAT TO DO???
Don’t Panic
Instead
ask questions
How Many Connections
• SQL Server Error Logs
• SQL Server Agent Logs
• Windows Event Logs
Developer
Application Support
Application
IT Admins
Production
DBA
Activity Monitor
Jobs Monitor
Performance Tuning
•
•
•
•
•
I/O distribution Analysis
SQL Server Resource Wait Stats Analysis
Index Analysis
TempDB Space Review
Database Files (MDF, NDF) and Log File
Inspection
• Review Hardware configuration