Share
Report
5Hi...I've been an RMS user over the years, have noticed something peculiar.
There are times where the SQL server (Sql Server Express 2005, in my case) seems to be painfully slow.
And when I mean slow, i mean REALLY slow, as in doing a simple select query like "select * from item where id=1) actually times out.
However, the physical server that the database is on, does not appear to be overloaded in anyway (low CUP utilization, low memory usage, even while the SQL server is slow).
Basically, the database will be slow for several days, and then, all of a sudden things would go back to being normal (fast database). I can't figure out why that happens.
I'm wondering if maybe this has something to do with the size of the database getting too big? But then why do things go back to normal (database fast), without me deleting any records etc?
Also, I don't think I have a virus on my database server, because all virus scans come up clean.
Anyone have any ideas?
*This post is locked for comments
All responses (
Answers (
