Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 About SQL Server hang

Author  Topic 

fazle_rabbee
Yak Posting Veteran

63 Posts

Posted - 2009-08-16 : 02:16:10
Dear All,

I am facing a tremendous problem for last 3 months. The Problem starts from 10 AM in SQL Server. I have found SQL Server hang that time in sql server and no user can login in SQL Server database. If i restart SQL Server or disconnect the network and then connecet, every one can access the database and can work daylong without facing further problems most of the time. Please give me solution if u have any. At the problem time the system idle process shows 98 or 99 % and no other activities in the server found accept SQL Server which shows 1%. Please Give me a proper solution so that the user can smoothly run the software.



fazle rabbee

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-08-16 : 03:03:08
What does SELECT @@VERSION show?

Run SQL Profiler to see what is leading up to this event.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -