ALZDBA (11/1/2011)

---

Just a way to import your default trace and query it... see attachment

( this one reports auto grow events ,should be peace of cake to have it filter detach...

Elliott Whitlow (11/2/2011)

---

I would probably handle the starting of the job as a Service Broker task. It separates the initiator from the executor very cleanly. It also means...

Which software is on your list at the moment?

It can mean trouble.

What are the results of the...

ehhh...same dead ends. I ended up installing the advisor on one of my 2003 servers instead of trying to run it from my desktop and the reports are happier.

I found this post through Bing. I am having the same issue. Did you ever find a resolution?

What does this say?

SELECT *

FROM sys.configurations

WHERE name = 'max server memory (MB)' ;

You can set the max amount the buffer pool can use by...

You saved yourself the headache of...

I know this thread is super-old but I am in the same boat...did you ever figure how to bring back the wrapper proc?

This is how I update a job step command via scripting:

EXEC msdb.dbo.sp_update_jobstep

@job_name = N'Job Name',

@step_id = 2,

@command...

My preference is to have each physical user log in with a different server login. From a troubleshooting perspective I like to be able to trace runaway processes to specific...

I thought...

How many physical users are you expecting to have to manage?

Have a look at the Start-Job CmdLet. Also, check the results of your favorite search engine when entering "asynchronous powershell".

To answer one of your other questions, fill factor is set independently on all indexes, clustered and non-clustered alike. i.e. you can have 100 on your clustered index and 90...