george sibbald (4/7/2010)

---

Question I don't know the answer to............In SQL2008 if you restore a master database from a different server and the server the backup originated from had a different...

Satish-219904 (4/6/2010)

---

From your responses so far,

I will add make the max. memory change and add the sql service account to "lock pages in memory" option. Hopefully these two changes will...

drawlings (4/5/2010)

---

I use perfmon to monitor PLE.

Lock pages in memory is advised only in cases where it proves to improve performance, experiment! In theory the setting should not be required....

yes its only user dbs and model, msdb to worry about

Hi

the values all have different meanings. The buffer cache hit ratio should be compared against buffer cache hit ratio base. Take buffer cache hit ratio and divide by the base...

ensure...

which monitoring tool do you use. Perfmon has a counter available for this or view it via the following query

select cntr_value...

something i have seen before, ensure you dont have a maint plan with a rebuild and a reorganise...

you can also perform a restore with...

what is the full command line you are using?

its worth pointing out that if the deleted account is not spotted straight away, the default trace may not be helpful. Depending how busy the server is as to how...

SPNs can be a problem here too

Your welcome!

darth.pathos (4/2/2010)

---

When I load the dvd, I get a list of links "Planning", "Maintenance", "Tools", etc.; nothing to indicate "Workstation Components", "Client Side Tools", or anything else. When I...

if granting the rights granularly as GSquared posted, just bear in mind that you...