Can we safley ignore the high avg disk queue length values, if the storage is SAN and consider only avg.sec/write & avg.sec/read? and if the values for avg.sec/write & avg.sec/read...

COuld you please give me some idea to aviod this blocking from Reportserver & Is our Report Server settings (see te attahment) in Reportmanger good or need to change any?...

Are your users running their reports from snapshots?

Is a new snapshot generated each time the run a report?

Is the snapshot cleanup fired off each time they run a report?

Are the...

Please advice me...

please advice me. I'm not clear on which direction I need go to defragment the share point database's indexes

please advice me how you guys are dealing with this

thanks

Here is how our nightly job is set up:

1) switch to bulk_logged

2) Reorg index if fragmented < 30%. Rebuild index in fragmented 30% or more

3) Update stats

4) Return to full...

Could you please give me some inputs!!

thanks

here between time 2010-02-25 23:34:12.957 & 2010-02-26 10:54:11.243 (this is the end time...

Hi,

I ran the below query to know report which is taking long time to run and I found one report took 40798568 (~11hrs). I did not understand why that report...

But MS says that it will NOT support if we use any other script to defrag indexes of share...

Thank you,

I'm already going through msdn. But I'm particularly looking for kind of e-learning classes for Upgrade to SQL Server 2008 and Upgrade SQL Server 2005 cluster to SQL Server...

I just need to drop the user and change the owner and map the database roles again right?

thanks Manu,

But after changing the owner to abc\btsadmin, I want to have the below database roles (these roles already exist now, with database owner SA and I want to...

Yes, the monitoring tool sends an alarm when the Disk queue length is >2

The no of disk...

DiskDescriptionType Size Device Type ...