I wish I knew...I'm going to follow this thread and hopefully some good input will be found 🙂

Neat question...not even sure how you could get it into memory..

Agree, what is the bad plan? What is the difference between the execution plans?

If it really is the execution plan that changes, not just performance, then look at your...

My guess...SQL Server Agent is connecting with a local system account.

Check who owns the SQL Server Agent Service, and what account is used by SQL Server Agent to...

'Profiler' seems to be the best way. I really like this tool although it does decrement Server performance. I may be missing something in your question though. ...

Unlike sp_who2, the sysprocesses table contains the login time along with the time the last batch was executed. For example,

SELECT sp.spid AS...

Not looking for anything specific. I found some templates, but they go into a lot of detail that I don't have time for. Thanks for the input 🙂

Jeff

...

There's lots of ways to do this. I have a couple of different things in place to handle this. I am emailed by a process whenevery any of...

Wait!! I read your message again. I'm guessing you are logging in with a user account that has a default database that it doesn't have access in.

Check and see...

lucg...try this

c:\>telnet 11.22.33.44 1433

Where 11.22.33.44 is the IP address of the server and 1433 is the port number. There could be a number of reasons why you can't...

That's a good one mjschwenger!!! Didn't think of disk fragmentation!!

This is what I have so far. No explanations are given on how to monitor these things..just a list of things to monitor. This is what I am...

Need more input here 🙂 I've come up with some more, but am sure there is plenty that I miss.....

This is great...AND yes I will post a full list. Some of the responses are great and I am sure I am not the only one who would...

Okay...Here is my list so far....

· Disk space available

· Database File size

· Potential for file growth and when files grow.

· Transaction log growth

· SQL Server Log file growth

· Tempdb utilization.

· Backups

· SQL Server Agent jobs

· SQL Server Error Logs

· Server...

I'll keep you posted as to my progress. I had already turned logging on and didn't find anything conclusive 🙁 Thanks for the input. Ironically enough...