February 2, 2004 at 10:08 pm
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,
February 3, 2004 at 11:18 am
This is something where if you called MS they wouldn't even talk to you until you applied the latest service pack, there have been so many fixes in all of the SP's that unless you have a reason not to, I reccomend you install the latest SP and see if your problem goes away. If it doesn't, then I'd start troubleshooting.
------------
Ray Higdon MCSE, MCDBA, CCNA
February 3, 2004 at 8:46 pm
Thanks for your response.
I have installed SP 4 on both the machines. The time taken to save the records has been reduced by few seconds. But the problem still persists.
Also, Win 2000 m/c is taking more time to save the records as compared to Win 98 m/c. What could be the reason ?
Regards,
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply