Database server extremely slow and poor performance
-
Hello, All of a sudden we are experiencing poor performance on our DB server, something that would like 5 seconds is now taking 25 minutes are not completing the query. Checked the sql server logs, nothing. Only difference is we have started to re-index all our indexes. We started this on Monday, and have schedules set up so that we have a few done every day. Does this hamper the performance? This is the first time the indexes are being re-indexed. Any ideas as where to look for SQL performance? Thanks!
-
Hello, All of a sudden we are experiencing poor performance on our DB server, something that would like 5 seconds is now taking 25 minutes are not completing the query. Checked the sql server logs, nothing. Only difference is we have started to re-index all our indexes. We started this on Monday, and have schedules set up so that we have a few done every day. Does this hamper the performance? This is the first time the indexes are being re-indexed. Any ideas as where to look for SQL performance? Thanks!
-
Hello, All of a sudden we are experiencing poor performance on our DB server, something that would like 5 seconds is now taking 25 minutes are not completing the query. Checked the sql server logs, nothing. Only difference is we have started to re-index all our indexes. We started this on Monday, and have schedules set up so that we have a few done every day. Does this hamper the performance? This is the first time the indexes are being re-indexed. Any ideas as where to look for SQL performance? Thanks!
This will help you too. How to Perform a SQL Server Performance Audit[^] Identifying performance issues using SQL Server Profiler[^]
thatraja
**My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
**