Re: Server stops responding

Ok, you may want to follow the tracks of the following counters to see the situation of Memory, Physical Disks, Network Card and CPU generally...

Memory: Available MBytes
Memory: Page Faults\sec
MSSQL$<your_instance_name>: Buffer Manager: Buffer cache hit ratio
MSSQL$<your_instance_name>: Buffer Manager: Page life expectancy
MSSQL$<your_instance_name>: General Statistics: User Connections
Network Interfce: Bytes Received\sec
Network Interfce: Bytes Sent\sec
Network Interfce: Output Queue Length
Physical Disk: % Disk Time (seperately for your OS and database disks, not total)
Physical Disk: Disk Read Bytes\sec
Physical Disk: Disk Write Bytes\sec
Physical Disk: Avg. Disk Queue Length
Processor: % Processor Time
System: Processor Queue Length

--
Ekrem Önsoy


"Altaf Al-Amin Najwani" <altaf.alamin@xxxxxxxxx> wrote in message news:B607126D-F7A9-46E8-9EFF-74247996223D@xxxxxxxxxxxxxxxx
Thanks Ekrem!

I am checking event viewer as well as sql server logs, both are silent about
this event. Secondly can you please recommend me any performance counters i
shall look for ? CPU runs at 35% utilization level .

Thanks in advance.

"Ekrem Önsoy" wrote:

Hello,


That's for sure you have problems with some services or something on your
Windows Server System or hardware I think.

Maybe it's the reason why SQL Server doesn't response sometimes?

You said there is nothing in the error logs, what error logs? Ones in Event
Viewer, or in SQL Server? Your should check both of them.

It seems it's nothing to do with SQL Server at first sight.

How about adding some counters to the System Monitor and check to see if
there is a bottleneck with one of your hardware components?


--
Ekrem Önsoy



"Altaf Al-Amin Najwani" <altaf.alamin@xxxxxxxxx> wrote in message
news:097CE843-9724-4F95-9990-CD5AAD53D135@xxxxxxxxxxxxxxxx
> Hi All,
>
> I am running SQL Server 2005 SP2 (Without SP1) on Windows 2003 Machine. > I
> am
> facing a very strange problem. Sometimes the database stops responding, > In
> this situation no user from my web application can connect to database.
> But
> If I go to server and open connection by management studio it works.
> Secondly
> I have also observed that the server becomes responsless for 3 to 4
> minutes
> and aftet that it again comes on normal behaviour. During all this it
> never
> writes any errors in log entries. Can anyone tell me the reason of it > and
> how
> it can be cured !!
>
> Thanks in advance.
>


.

Relevant Pages

  • Re: sql memory planning w/ perfmon
    ... What counters should I be looking at to determine actual memory ... you should put as much memory on the server as SQL Server can ... Limiting the amount of data SQL Server has to read when running queries ... leaves the important data in the data cache and prevents physical disk ...
    (microsoft.public.sqlserver.server)
  • Re: Server stops responding
    ... you may want to track your database with SQL Server Profiler to see if some processes takes longer then they should take. ... Physical Disk: % Disk Time (seperately for your OS and database disks, ...
    (microsoft.public.sqlserver.clients)
  • Re: Cluster configuration with SQL Server 2000
    ... > - I can't create a new group, because I have only one physical disk. ... > - Is it possible to install SQL Server 2000 using the cluster group? ... Everything in the configuration you mentioned ...
    (microsoft.public.windows.server.clustering)
  • Re: Change Drive Location for Log Files.
    ... dependency to the logs physical disk resource and bring sql server back ... > of the instance/Database settings/default log directory, ... > the other active drives. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Disk Requirements
    ... Network Name ... Physical Disk ... Physical Disks ... SQL Server Agent (INST1) ...
    (microsoft.public.sqlserver.clustering)
Loading