Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SQL Server 2008 random "go slow" for two minutes

Avatar of deepsix
deepsix asked on
.NET ProgrammingASP.NETMicrosoft SQL Server 2008
20 Comments1 Solution1223 ViewsLast Modified:
We are running SQL 2008 Enterprise server with ASP Persistent sessions and our main data DB on the same 2008 Enterprise server. We're currently experiencing random freezes where all websites and applications accessing the DB become un-responsive.

Looking at the activity monitor in SQL Server Management Studio there is nothing out of the ordinary whilst the slow-downs occur. However, there are huge spikes randomly. The "Waiting Tasks" leap from between 0-10 as they normally are to 80,000 and the DB I/O leaps from the 0.3-1MB/sec it normally runs at up to 80MB/sec.

I think that the huge spikes may be due to the ASPState table doing a Commit. I managed to catch it once and it had huge IO so I don't think that this is part of the problem.

Are there any tests I can run to find what is causing the slow down? Our websites use a lot of ajax (one request every three seconds per customer) and we have a ~200 users on the websites concurrently so using the profiler is extremely difficult.
Avatar of Anthony Perkins
This problem has been solved!
Unlock 1 Answer and 20 Comments.
See Answers