MS SQL Server slows down over time?
- by Dave Holland
Have any of you experienced the following, and have you found a solution:
A large part of our website's back-end is MS SQL Server 2005. Every week or two weeks the site begins running slower - and I see queries taking longer and longer to complete in SQL. I have a query that I like to use:
USE master
select text,wait_time,blocking_session_id AS…