/*Thank for the head-up. But will this explain the reason why my SQL server

over-consumed hardware resources and ended up not responding? */

I guess I...

Plan looks okay to me and the query also looks like to have completed in 5 seconds. Looks like ur server as a whole isn't healthy..If you want optimize this...

@s-2 t e f

He has Rebuild the index which implies stats are updated.

Also, the Original poster claims that people cant login or access the server which implies the problem is...

hmm..I kind of guessed this when you said users cudnt connect..

Please check the following..(some of the stuff u wud have already checked..but anyways..)

> on System task manager check how...

/* SELECT query with a basic WHERE clause, the SQL Server basically slowed down to a snails pace. Resulting in some users unable to connect to SQL Server. */

Are u...

Yes..The table may be heavily fragmented. Perhaps you can Rebuild the clustered index offline, if you have nobody else using it.

There are quite a few threads in this forum which...

@rithesh,

Thanks. If i mananger to find smthng on CPU, i will post it. 🙂

@Omprakash K Deshpande,

SQL Alert helps monitoring fatal errors and SQL counters. CPU % falls under

windows counter and...

@ritesh-2,

That's not smthng i was looking at as it goes away from sql..and involves lot of manual configuring alert on each server. Also, when one monitors lot of servers, you...

Any idea on how to capture CPU % used by sql server?.

I mean CPU % shown in task manager or process - Processor%time-> perfmon counter and not the CPU cycles...

or simply

declare @overallavailablity decimal (18,4)

select @overallavailablity = 676.0000/10080.0000

print @overallavailablity

try this!!!

declare @overallavailablity decimal (18,4)

declare @numerator decimal (18,4)

declare @denominator decimal (18,4)

sET @numerator = 676

SET @denominator = 10080

select @overallavailablity = @numerator/@denominator

print @overallavailablity

@jeff,

His sample result has 19,20 and after that 8,9. So I guessed he felt he needs it in the order in which Database stores ( or unordered scan resultorder ).

If u want it in the order in which its stored in the database then its not possible. You may need to create a column with auto increment. Database can...

If u have gaps then u can try this

Select current_seq.*,next_seq.* from

(

Select *,row_number() Over (order by id asc ) as seq

from tablea ) as current_seq, ( Select *,row_number() Over...

Welcome 🙂