SP2 make SQL server run slow

[PGtips]

I've been running MSSQL on several different PC's for some time with no
problems. All except one PC runs XP SP2.
When I installed SP2 on the remaining PC, MSSQL on that PC is running
extremely slowly. It's also slow if I try to use a database running on a
different PC.
When I uninstall SP2 it allows MSSQL to run at it's normal speed.

Has anybody any idea how to fix this problem. I'd really like to use SP2 on
all these PC's.

Pete G.

 

[Guest]

I was noticing some problems with SQL Server when upgrading from 2000 to XP.
Have you upgraded SQL Server to SP4? I was seeing errors in the Windows
System logs from SQL Server. If accessing the SQL Server remotely, you
will need to make sqlservr.exe an exception for the firewall.

Brian

 

[Gerry Hickman]

I was noticing some problems with SQL Server when upgrading from 2000 to XP.
Have you upgraded SQL Server to SP4? I was seeing errors in the Windows
System logs from SQL Server. If accessing the SQL Server remotely, you
will need to make sqlservr.exe an exception for the firewall.

The part that worried me was where he said he was running SQL server on
XP! What's with that??

 

[PGtips]

Thanks for your reply, Brian. I have tried every update there is. It's just
one of my PC's out of five that has this problem. When I uninstall SP2,
MSSQL then works fine at it's normal speed. I've tried installing MSSQL
before installing SP2 and after installing SP2 all with the same result.

It's the development version of MSSQL that I have installed, as comes with
MSDN and the reason I have it on XP is because that's what I'm writing my
software for. I also use MSDE and get the same results.

It's just one of those strange problems that is driving me mad!!!

 

[Gerry Hickman]

It's the development version of MSSQL that I have installed, as comes with
MSDN and the reason I have it on XP

Ok it makes more sense now. You should have mentioned that at the
beginning, as I only have test results for the production version.

Out of interest, are you able to use the "Full Text Index" menus in
Enterprise Manager? We are finding them grayed out on XP machines with
the development version, but working fine on Win2k machines.

 

[Gerry Hickman]

It's the development version of MSSQL that I have installed, as comes with
MSDN and the reason I have it on XP is because that's what I'm writing my
software for.

But how will this work in reality? How will your XP customers get hold
of the development version of SQL server? Surely better to use MSDE, but
that's a nightmare for the end-user and constantly needs patching, and
the deployment is horrible?

I thought the MSDN dev version was more for people who want to test
server production systems off-line?