Dale Fye
asked on
SQL Server running extremely slowly.
One of my clients has a large Access application running against a SQL Server BE (2012) which has been running along smoothly until last Thursday, when reads and writes from/to the SQL server slowed significantly, and are resulting in ODBC timeout errors when writing to various tables.
The client rebooted the server over the weekend, but the problem persists.
All of the various services (SQL Server, agent, browser, reporting services) appear to be running.
Just looking for any input from those of you with extensive SQL Server experience on where to look in the Windows or SQL Server logs to see if I can figure out what is going on?
The client rebooted the server over the weekend, but the problem persists.
All of the various services (SQL Server, agent, browser, reporting services) appear to be running.
Just looking for any input from those of you with extensive SQL Server experience on where to look in the Windows or SQL Server logs to see if I can figure out what is going on?
Look at hdd problems (failed disk in raid, etc), general performance (cpu and memory usage)
What version/edition of SQL is running? You could use SQL own "Performance Dashboard Reports" - they are great! - to debug all kind of real time issues in SQL Sever.
https://www.microsoft.com/en-ca/download/details.aspx?id=29063
Also, was there any change before " last Thursday, when reads and writes from/to the SQL server slowed significantly" on the Access application side OR on the SQL Server? Patching, etc? Any new software installed or updated - antivirus in particular?
https://www.microsoft.com/en-ca/download/details.aspx?id=29063
Also, was there any change before " last Thursday, when reads and writes from/to the SQL server slowed significantly" on the Access application side OR on the SQL Server? Patching, etc? Any new software installed or updated - antivirus in particular?
what often happens: check if tempdb is on HDD volume C:\ and C:\ runs out of space
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.