Too much time to save records

[ek07]

Hi,

I'm using MS SQL Server 7 as a backend for a Delphi 4 application. SQL Server is running on Windows 2000 without any Service Pack. I also have another SQL Server running on Windows 98 without Service Pack.

On connecting application to SQL Server running on Win 2000, some records take 2-3 mins to save after editing whereas other records save in 2-3 seconds. This problem is coming up quite frequently.

However, on connecting to SQL Server running on Win 98, the time issue do come up but not as frequently as in the above case.

Could any one please tell me if absence of Service Pack effect the performance of SQL Server ? What could be the reasons for SQL Server to take so much of time to save records ?

Also, what could be done to fine tune SQL Server performance !

Regards,

 

[SQLBill]

I suggest getting your SP's updated and quickly. It may or may not be the issue, but there still is a 'bad' worm called SQL Slammer. SP 3a for SQL Server 2000 fixes it, I don't know the SP # for SQL Server 7.

If you are infected by that worm, it can cause a problem. But either way, you really need to get caught up on SPs.

Another thing that can be causing the slow performance is if there is anything else being run on the slow machine.

Also, what kind of memory/CPU do you have on each machine?

You might run Profiler to see what's happening on your systems.


-SQLBill