Link to home
Start Free TrialLog in
Avatar of Dale Fye
Dale FyeFlag for United States of America

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?
Avatar of als315
als315
Flag of Russian Federation image

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?
what often happens: check if tempdb is on HDD volume C:\ and C:\ runs out of space
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial