Sudden change in access times to MSSQL.
So I have a long running process that reads and posts to an MSSQL database, and the time to execute a simple embedded SQL query
PHP Code:
select Count(1) from foo where foo.status = 1
increases over the course of a few hours from 16ms to 3500ms, and cpu usage goes from 2% to 25%
Has anyone any suggestions?
Michael Mullan.
Danes Bridge Enterprises.
++++++++++++++++++++++++++++
There is just today. Tomorrow is a concept
that is mostly theoretical. -- GM Wylie
++++++++++++++++++++++++++++