Re: Installing sql server 2000 sp4.

Tech-Archive recommends: Fix windows errors by optimizing your registry

SQL with SP4 reports blocking a little differently than before. This isn't
a new problem, it is simply more visibility on how your server always
behaved.

The blocked column in the sysprocesses table is populated for latch waits
after you install SQL Server 2000 SP4
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B906344



--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"MariaGuzman" <marisa@xxxxxxxxxx> wrote in message
news:eFBhAuz0FHA.1032@xxxxxxxxxxxxxxxxxxxxxxx
> Hi, I installed sp4 on a server that is runnig sql server 2000 standard.
> I'm evaluating how the server works. On this server I execute some
> processes that take almost 20 minutes to finish. After I apply the sp4,
> the process take more than 1.5 hours to execute and it doesn't finish I
> have to stop it.
>
> While the process is running I saw in enterprise manager that the spid
> that is executing the process is blocking it self. It have never happend
> before the installation.
>
> We make a backup from that database and restore it on another server
> that has sp3 installed and the process take almost 20 or 25 minutes to
> execute. (normal time for us)
>
> Do somebody know I the sp4 is causing this kind of problems??
>
> Or somebody have ever have this problem with this sp???
>
> Thanks a lot for your help.
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: Stored procedure/trigger and scripts
    ... SQL Server has permissions to execute xp_cmdshell. ... Please read up on xp_cmdshell within Books Online (within the SQL Server program group). ... >> client to change their password they have to call the "Client Relations" ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem with bulk load security.
    ... The only user that didn't have the bulkadmin roll was the ID that SQL ... Did you to EXECUTE AS USER or EXECUTE ... Links for SQL Server Books Online: ... DDL Triggers with Server Scope and logon triggers ...
    (microsoft.public.sqlserver.security)
  • Re: Full Text Repair
    ... Emil Caruthers ... > Since your customer has already applied SP4, I'm assuming that this is a SQL ... > For SQL Server 7.0 installations, there is a registry key and value that you ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL Server SP3 vs SP4 questions
    ... SQL with SP4 applied, SPS front-end web server with SQL client tools at SP3, ...
    (microsoft.public.sharepoint.portalserver)
  • Re: DTS package not executing from within a webservice
    ... method on the Server A which has a web method, Am trying to execute a DTS ... created a wrapper and using the methods of the DTS.dll ... Not associated with a trusted SQL ... Server connection. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)