the issue i have with procedures like these is that the developers at our place create a procedure for all eventualities which is fine BUT, a lot of these optional...

FYI

Response:

I think that's what happens by design when you restore a full/log backup on SQL Server.

I did some quick tests on SQL Server 2000, and the buffer cache drops all...

thanks, i have done so lets hope something comes from it 😀

now sorted 😀

Redgate have now opened this as a support request due to no responses on their forum......i'm stumped at the moment with this - am i the only person to get...

thanks for that. Yes SQLBackup does use extended storedprocedures and this is what is issuing the waittype but the question is why? The restore should take seconds not minutes and...

cheers for the replys guys, panic now over. Couldn't connect via sqlcmd so thought i'd close all services (ie RS etc) in order to claim as much memory back as...

i'm meeting again with him atoday so i will ask regarding the DMK but he did say last week that the password would require changing as well as the Certs/Symmetric...

have you tried PerfMon? Check things like the buffer and proc cache

have a look here:

http://performancepointblog.com/2008/06/sql-reporting-services-what-does-that-thread-pool-pressure-warning-mean/

i've had the very opposite experience with SQLSentry. Any questions or issues we've had have been responded to and answered within a few days..........could be that our issues were easily...

we went though a similar exercise a few mths ago. I liked Foglight but as ppl on here have said, it was way way too slow for production use. If...

but i can't understand why if the page life expectancy is 800, its not trying to starve the server? If it were 8000 then i'd agree, not many pages are...

i'm not having performance issues but i'm interested in knowing why a sql server that is set to consume max amount of memory allowed is only using 13.2GB when there...

:w00t:bump:w00t: