I'm getting the query using SQL profiler and spotlight which is causing PLE to drop and taking more CPU. But the the query is with variables. How to get...

so there is no way to list the staled statistics in sql server? other than getting when stats were last updated?

I want to update stats that are staled not all...

Gail, I want to capture the sql statements when PLE drops. what is the best method?

We have spot light, I'm able capture queries from spotlight but they are not complete....

after 1 day, I'm again seeing PLE going down <5 mins:crying:

what counters should we monitor to find out lowmem signal from windows?

thank you very much for your inputs

Thanks for the detailed information Gail.

instance1 is using 1.42GB out of 6GB and instance2 is using 554 MB out of 6GB.

But one thing I did not understand is, 2...

Gail,

Issue got resolved after setting up the Min memory to 1gb for both the instances

Can you please shed some light on this Min memory setting? i.e which scenarios we need...

Thanks Gail,

I just noticed that instance1 is using 364 MB out of 6GB (it was 2.9 GB 6 hrs back) and instance2 is using 3.4 GB out of 6GB.(it was...

Hi Gail.

I just noticed that instance1 is using 364 MB out of 6GB (it was 2.9 GB 6 hrs back) and instance2 is using 3.4 GB out of 6GB.(it was...

Max server memory is just the upper limit that SQL is allowed to use. There's many cases where it won't reach that. Ones that immediately come to mind is it...

If we comment out the below sql, then each and every database backup information will be logged, which we are not interested in.i.e

Log was backed up. Database: db1,...

Hi Rudy,

Can you also include alert mechanism to send the error detail in an email so that DBA can quickly act on it?

Thanks,

Gary

Can you please list out some recovery scenarios in general to test and document?

I' m able to get this done. But I don't think this is correct way creating tables and dropping tables and selecting data twice.Can you please provide me a better...

Thanks Homebrew,

I tried giving '' quotes but its failing with the below message:

(95 row(s) affected)

Msg 22050, Level 16, State 1, Line 0

Error formatting query, probably invalid parameters

Msg 14661, Level 16,...