Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL locking up server
Message
De
10/08/2004 08:48:41
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
SQL locking up server
Divers
Thread ID:
00932005
Message ID:
00932005
Vues:
67
There has been an infrequent occurrence of one server (it is a domain server, a web server, and a SQL server; it is pretty strong), becoming extremely slow, and then inaccessible. It has been on Monday mornings that this has happened, when we get back into the office. If we can shut down SQL server, especially SQL Server Agent, the problem goes away.

This last time, I was able to get a snapshot of the Process Info. It had about 100 identical sleeping processes:

user = NT Authority\System,
database = websiteActivity (set up to receive IIS logging info of the website),
command = Select,
status = sleeping.

OS = Win Server 2000 (up to date)
SQL = SQL Server 2000 (up to date)

I do not know what is initiating the NT Authority\System connections. Again, the occurance is infrequent.

Help in this area is very much appreciated.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Répondre
Fil
Voir

Click here to load this message in the networking platform