i think wintel tean must be knowing about it .... should i ask them about Storage foundation version?

ok thanks Gail 🙂

ok.... got your point ...

but windows team and client team always send the screen shot of high memory utilization and tell us they are getting alert because of SQL high...

Gail,

but for now is there any thing in sql or windows which i should check????

anthony,

today since morning it is showing that sqlservice taking more than 100 GB, i checked in backend current running querry which are very less, no blockages and all query taking...

but if it can go beyond the max server memory limit thn what is the feasibility to define it, please elaborate as i am unable to convince myself.

anthony,

we dont have backup of msdb, and as far as i know there is no setup of custom logging, if we want to do so please let me know how...

what i did actually i created a same table as mentioned in attached image and created index on each of the column then ran count(*) and saw execution plan it...

hmmm thats what i expected, its a great idea... it definitely shows index seek, but practically it really improves performance or it just shows index seek???

hehe yes, its a question i faced in a test, i got the answer that is third one,it'll use index available on deptid. but need an explanation why optimizer...

one last question,

suppose i am using select queries like this frequently

select * from T where id =6

select * from T where ch ='!'

select * from T where na ='sue'

so i'll...

got clear lot of things.

that mean is these indexes both are same and will work same way.

create nonclustered index NC_T2 on T(id,ch,na)

CREATE NONCLUSTERED INDEX [NC_T] ON [dbo].[T] (id )

INCLUDE (ch,na)

laurie,

your last statement is if i fetch complete table sql is not using any of the index,

thats correct its not using any index, but why is this so table having...

ok got it, meaning is which select query will have "id" in where clause, that one will have seek operation others will have scan operation.

that is clear but, what will...

in cluster log nothng found same error as follows:

Cluster resource 'SQL Server' in Resource Group 'SQLVS01' failed.