Re: Microsoft SQL Server 2000 - 8.00.2039 cause blocking problem

Are you looking at the results of sp_who / sp_who2 or "Current Activity"
within Enterprise Manager?

Microsoft increased the amount of information that is displayed with SQL
Server 2000 SP4. You might see more blocks because of this. Is performance
suffering?


http://www.support.microsoft.com/?id=224453 Blocking Problems
http://www.support.microsoft.com/?id=271509 How to monitor SQL 2000
Blocking
http://www.support.microsoft.com/?id=899976


--
Keith Kratochvil


"soonyu" <soonyu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0EF1FD4D-B15D-4CA3-85E3-B1EBE0EDAB69@xxxxxxxxxxxxxxxx
After install sp4, the query keep block by it own
and ghost cleanup keep appear there?

Any idea?



.

Relevant Pages

  • 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: Full Text Repair
    ... 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 ... It will contain your hotfix build version number such that 7.00.xxx is the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Scenario 1" in SQL Server 2000 Books Online. ... Run Database Components SP4 Setup on the node you have ... DBC01 (SQL Instance 1) ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to run SQL Query Analyzer ......
    ... SP4 to both the default instance and SharePoint instance, ... I have a SBS2003 Premium Edition with SQL 2000 installed. ... MSSQL$SHAREPOINT, and Active Server Pages: ...
    (microsoft.public.windows.server.sbs)
Loading