Re: Server stops responding

Even if it would be good to see "System: Processor Queue Length" too, other results are quite good. Only "Page Faults" looks a bit high but it must be something else or you may want to dig it.

Besides, it's very important when did you analyse these hardwares and how long did it take.

You may be experiencing problems with CPU? because %60 is not a bad resuld nor very good. Maybe in peak hours this value jumps to much higher? And that may be resulting with pauses? This is just a guess.

You may want to have a look at the processes that runs from the Task Manager and see if there is a cpu\ram consuming process running. If so, track it to see what it is about exactly.

--
Ekrem Önsoy



"Altaf Al-Amin Najwani" <altaf.alamin@xxxxxxxxx> wrote in message news:5E9E21E3-B1B8-4E1B-AC07-6279B4A53C17@xxxxxxxxxxxxxxxx
Thanks for your reply. I have added all these performance counters and here
are the readings :

Memory: Available MBytes = 1294
Memory: Page Faults\sec > 250 (Sometimes)
MSSQL$<your_instance_name>: Buffer Manager: Buffer cache hit ratio = 99.3
MSSQL$<your_instance_name>: Buffer Manager: Page life expectancy = 3091
MSSQL$<your_instance_name>: General Statistics: User Connections = 55
Network Interfce: Bytes Received\sec = 2000 to 10000
Network Interfce: Bytes Sent\sec = 2000 to 10000
Network Interfce: Output Queue Length = 0
Physical Disk: % Disk Time (seperately for your OS and database disks, not
total) = OS : 5 to 20 | Database : 0 to 1
Physical Disk: Disk Read Bytes\sec , OS: 0 | Database : sometimes greater than 90,000
Physical Disk: Disk Write Bytes\sec, OS: 0 to 5000 (Sometimes 25,000) | Database : 0 to 115000
Physical Disk: Avg. Disk Queue Length = almost 0 and less than 1
Processor: % Processor Time = 0 to 60
System: Processor Queue Length


I would appreciate if you can have a look at the above readings and tell me
where is the problem.

Thanks in advance.


"Ekrem Önsoy" wrote:

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: Server stops responding
    ... Network Interfce: Bytes Received\sec = 2000 to 10000 ... Physical Disk: % Disk Time (seperately for your OS and database disks, ... Maybe it's the reason why SQL Server doesn't response sometimes? ...
    (microsoft.public.sqlserver.clients)
  • Re: [GIT PULL] Ext3 latency fixes
    ... which unplugged the write queue after every page write. ... In guarded mode the on disk i_size is not updated until after the data ... The end_io handler puts the buffer onto the per-sb list of guarded ... One big gotcha is that we starting a transaction while a page is ...
    (Linux-Kernel)
  • Re: [GIT PULL] Ext3 latency fixes
    ... which unplugged the write queue after every page write. ... In guarded mode the on disk i_size is not updated until after the data ... The end_io handler puts the buffer onto the per-sb list of guarded ...
    (Linux-Kernel)
  • Re: Higher than expected disk write(2) latency
    ... The disk is a Seagate ST380817AS SATA connected to an Intel ICH7 ... "You write sector n and n+1, it takes some amount of time for that first ... Crosses are operations enqueue times (when write requests were ... AIO queue are slowing down the retrieval from the queue and thus we miss ...
    (Linux-Kernel)
  • Re: Exchange 2007 get-mailboxstatistics hangs
    ... I have found 3-4 users with item counts in their mailboxes exceeding 5000. ... My logical disk counter avg. ... Is there not a way to just simply restart the queue (suspending ... RPC Averaged Latency (been running high in the 15-60 ...
    (microsoft.public.exchange.setup)
Loading