August 20, 2008 at 12:53 pm
Hi, I am relatively new to SQL. I have three databases running on SQL 2005 server. This 3 databases (1 for payroll, 1 for accounts payable and 1 for a Customs system- all of them form different vendors), were working just fine for about 1 Year. About 1 month ago, one of the Databases (Customs), is having some kind of slowness. There is one process this database does, which is to verify some part numbers- This query took about 1 or 2 minutes, nowadays, it takes about 10 to 15 minutes!!!. We did some repairs, check indexes, shrinks, deleted the Log file (which BTW grows big, about 1GB) the MDF is about 2GB.
Well, the only thing we found out to be effective was to Stop and Start the SQL Service with this commands on a batch file I took from a web site:
@ECHO OFF
NET STOP SQLSERVERAGENT
NET STOP MSSQLSERVER
NET START MSSQLSERVER
NET START SQLSERVERAGENT
When I run this, the query takes again 1 to 2 minutes., but next day, the same thing happens.
I don't want to run this everytime I have problems, because, there are another users, using the "other" databases, and I guess that can cause troubles somehow.
Question: What can be causing this behavior?, is there any "log" I can check ?, How should I approach this problem?
Thanks.
August 20, 2008 at 3:11 pm
Which service pack, if any, are you using on the SQL Server?
N 56°04'39.16"
E 12°55'05.25"
August 20, 2008 at 3:23 pm
Sorry I stated that it was 2005, but it is 2000
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
8.00.2050
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply