I have Updated stats for the Content database to see whether it's reduces the blocking and noticed that only the below 10 tables required to update stats

1. AllDocs

2. AllDocStreams

3.GroupMembership

4....

And I also verified the stats that last updated and it is on 4 days ago.

Is that mean Auto update stats assumes that the stats are up to date and...

I have verified the Index fragmentation for the Content databases and there are only <10 indexes fragmented (I have considered page count>500

and I'm Performing Index defrag weekly.

Auto update stats is...

Hi,

I'm getting calls from users saying that Share Point application running slow!! Is this degrade in performance because of the blocking?

But this is kind of internal blocking (as same...

Could you please shed some light on this issue??

I did not get any resolution to go forward:hehe::hehe:

Thanks

I

f you have multiple instances on the server then All counters refer to the counter value for all the instances together or you can get the counter value for each...

Could you please advice me...

Thanks

Thank you Sanjay..

Its very helpful..Does this documented in BOL? If yes, could you please point me to that link..

Thanks

Thanks Miller,

Here the SPID 65...

Thank you,

I'm using the below stored procedure to backup the databases:

I have created the below Stored Procedure in MASTER database:

USE [master]

GO

/****** Object: StoredProcedure [dbo].[BackupDB] Script Date:...

You can also include rebuild indexes...

You only need the client tools and SSIS on the passive node if, and only if, you think you might want to use them when the cluster has failed over...

Ajitgadge,

Hi,

You can capture blocking queries / sql statement and it's related infirmations ( like CPU usage, I/O , read-write memory etc. ) and send it to your email id. Basically...

RAM = 16 GB

Max Memory = 12 GB

Min memory = default

Lock pages in memory is enabled.

Page file size = default= 2046...

sorry,

Here is the attchment! and lock pages in memory is enabled.