John,

Are u get any error in sql server errorlog like memory paging out

Already i told counter value is good Check the sql/OS error log

I considered the following counters mainly and they are at its optimum value indicating less paging.

SQL Server: Buffer Manager: Buffer Cache Hit Ratio – 99.8 % (Higher value optimum)

SQL Server:...

Hi,

Read & use the index de-fragmentation script added in my signature.

Hi,

Please run & verify the following in master

Exec Xp_cmdshell 'dir \\datadev01\d$\DBA\Thitesting\DBA.bak'

newdb (12/1/2009)

---

Muthukkumaran,

I can not find the error anywhere. I even ran these commands

use msdb

Select * From dbo.log_shipping_monitor_error_detail

and it's not showing any error. I looked in the SQL Agent...

doug turner (12/1/2009)

---

Thanks. The indexing helped a little. I'm up to 1.6Gb free now. It looks like some major table cleanup is in order to really free...

Thanks for DMV's Gail .Always i learned lot from u.

Hi

Read the 1'st link added in my Signature.

Hi,

Thanks for script George Sibbald

chris,

U can use this query also

select * from sys.sysprocesses where blocked <> 0

Yes,I agree with George Sibbald

chris.worthington,Please run the Server-side trace for this situation

Hi,

Read the Paul article

Hi,

You can't control when it kicks in. Although it doesn't have any effect like long-term blocking, it does take up a lot of resources, both IO and CPU. It also...

doug turner (12/1/2009)

---

I have a replicated database that has grown to 51Gb. I'm limited to 60Gb, so I need to do something to shrink this guy. I've deleted...

Possible Errors

* No targets found

The target set could be empty due to any of the following reasons:

...

Additionally,

Log Shipping