What do each of your disk represent? D, E, T, Z, Q, Y? For your avg. disk sec/write and read to be in seconds instead of ms, there is got...

We also have the same issue and it may the issue with application url that unable to recognize the sql instance

Thank you Adiga,

How to Stop & Start the SQL Server Services Full Text Search, Integration Services and Reporting Services from Command prompt?

Thanks

The database that I tested the compression is a Share Point Content Database.

May be it contains data that cannot be compressed much! I will try the compression with non share...

Thank you,

As it's an instance hosting Share point database, I think it's NOT possible to mention MaxDop value in individual queries. So I have only one option of setting server...

Could you please advice me

Thank you

Thanks SQLGuru,

CXPACKET: You have either too little ram, too poor an IO configuration or both. Drop MAXDOP to half the cores (non-hyperthreaded here) and try that.

For network packets, quite a...

could you please advice me..

thanks

Thanks Gail,

I'm using the below script which defrag the indexes based on Avg.Fragmentation_in_percent

<30 reorg

>30 rebuild

In our case, all indexes have Avg.Fragmentation_in_percent <30 so it's doing only Index reorg and lot...

Thanks Andy,

I tested the restore from a network share and it was successful:-)

thanks

I ran the below query to find out the wait types:

and noticed very high values for CXPACKET, SLEEP_TASK,ASYNC_NETWORK_IO

select * from sys.dm_os_wait_stats

where wait_type in('CXPACKET', 'SLEEP_TASK','ASYNC_NETWORK_IO')

Results:

wait_type ...

Hi,

We have two quad core CPU's .i.e 8 CPU's.

So in this case, what would be the best value for MaxDop setting?

Thanks

Thank you, Paul.

I have read through the waits and queues documents at a high level, but I will go back to it and study it more carefully, as well as...

Auto update statistics fire when collumn change 10% of rows on tables larger then app 500 rows.

Is it possible in your situation?

Thanks..I will check for no.of rows in each table...

Could you please advice me..

Thanks