456789psw (9/20/2010)

---

This pretty much tells you that this instance is ok,

you should run profiler and capture all the other instances at the same time....that way you can run one trace....save...

456789psw (9/17/2010)

---

This is simple....run your perf mon look for Page life expectancy(sql server memory), for each SQL instance. make sure the PLE is no less then 300, preferably higher like...

456789psw (9/18/2010)

---

hard to tell with just this since its a snapshot many things can happen between snapshots, example what if the OS ran out of memory a min before you...

Mandar Alawani (9/17/2010)

---

TO find memory usage

select object_name,counter_name, cntr_value 'Memory Used Size (KB)'

FROM

Sys.dm_os_performance_counters

where object_name like '%SQLServer:Memory Manager%'

also you can add the same performance counters in PERFMON

also, i have a smal...

The reason for multiple instances is because the application is only capable of calling multiple DB paths, not multiple database names. If we had to deal with multiple DB...

Yeah looks like I read that page wrong. Sorry for the confusion.

However I'm not detaching the DB's when I move them, I'm simply taking them offline. I'm really...

Andrew thank you for looking. I was under the impression that the sp_detach_db was being deprecated and should no longer be used.

http://weblogs.sqlteam.com/dang/archive/2009/01/18/Dont-Use-sp_attach_db.aspx

Essentially I need the DB files...

I wrote this and thought I might share as I have had a need for something similar.

USE master

/* Mixed Authenication script SR 01-14-10, can update SQL authentication for instances.

works with...