Hi SoHelpMeCodd,

Thanks for your inputs. We did used the polling interval of perfmon as 5 secs. I need to try the storport tracing and see.

Thanks again.

Why could CPU ratio can be a problem? could you please elaborate ?

Hi Gail,

We do see high latency values over a sustained period of times. But SAN guys are stating they don't find any latency at LUN layer from their end....

Thanks Gail.

Thank you.

Thank you Sir for the advise. Will involve network team.

Okay Thank you. Does sql always logs this message or only whenever large amount of working set trims will get logged in SQL ERRORLOG? Checking if there is any...

Awesome. Thank you all for sharing thoughts. Will try 1 by1.

Thank you all. Valuable info.

How to find that every 20 mins it gets updated? any query ?

My SQL Version is :Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Developer Edition (64-bit)

Thanks Jeff for your inputs. Indeed makes a lot of sense!

Can anybody help?

Thanks for the sincere response.

1. Firstly, what all are the possible ways to fix this ?

2. Secondly, is there any demo scripts available on sample database to get...

Thanks Ian. Indeed very helpful switch -f.

Finally, was able to the query Gerald. Thanks for the help.

declare @dt1 datetime

declare @dt2 datetime

set @dt1 = GETDATE()

set @dt2 = GETDATE()+1

select distinct name,description,

convert(varchar(20),next_scheduled_run_date,100) as ...