Check out this thread from today... http://www.sqlservercentral.com/Forums/Topic635427-149-1.aspx#bm635522

However, the template file will be usable in Profiler. If you script it out then you can run it via SSMS or a job and still have the same configuration...

There are many tools available from places like Idera, Quest, Red-Gate, Precise, etc. Many of these tools can be really overwhelming. I have found that the Red-Gate tool seems to...

Funny as I just posted a link to this on another post earlier today but, here it is again.

http://stackoverflow.com/questions/257906/ms-sql-server-2008-how-can-i-log-and-find-the-most-expensive-queries

Side note, I haven't tried this with 2000 but my guess...

Yes, that would be the case. Just trying to understand the situation that Sam was seeing. May be one of those unexplained phenomena of the world of technology but I...

Understood. Yeah, unfortunately there really is no cut and dry answer when it comes to performance tuning for queries hence why DTA can sometimes struggle. Ultimately what you are doing,...

Not sure if you knew this but you can actually post scripts to the Script section on this site for others to find and use long term so, you might...

Mike - I am a bit confused how clustering could be a solution as it is truly a HA solution for hardware failures. Can you expound more on how you...

I think Brandie wanted to script out the template, which I believe this will accomplish. Hope so anyway, hate to answer the wrong question. 🙂

Should have put this in originally so the information could be on this thread as well. From the link above;

Briefly start the trace and then pause it. Goto...

Brandie - I think the following link will give you the information you are looking for;

http://stackoverflow.com/questions/257906/ms-sql-server-2008-how-can-i-log-and-find-the-most-expensive-queries

The title is a bit misleading as it does talk about getting the script...

Sorry Sam - have to ask 😛

Was this person running a query against the database you were dropping?

The OP stated that the data was only updated once per month so, the solutions offered should be sufficient and should allow for very minimal downtime - or am I...

Yes, and you could rename the servers at the end so that your application would not have to be changed.

Mike Levan (1/12/2009)

---

My idea: Finish dataload process in staging and get ready to move into production. Move mdf file onto production. Dettach the respective DB on Prod1 and attach the...