Jeffrey Williams 3188 (12/9/2011)

---

Here is what I would do...

Set a max size on each tempdb file so you don't exceed 100GB - since you say it normally doesn't grow much....

MyDoggieJessie (12/8/2011)

---

Difficult to tell with out a StartTime reference as well but those are some seriously long durations. Looks to me that a LOT of SSIS jobs are running...

matt.newman (12/8/2011)

---

Could skim through SQL agent jobs execution time for anything that ran around that time if applicable. There might be a 2 day trend in activity for one job...

I need to go back and look at 2-3 days worth. I am no expert at looking at trace data, although I see some intensive items, still need to...

SkyBox (12/8/2011)

---

MyDoggieJessie (12/8/2011)

---

Have you checked your SQL Logs? Have you checked the default trace file (should be in the log folder of your default SQL installation folder) to see...

MyDoggieJessie (12/8/2011)

---

Have you checked your SQL Logs? Have you checked the default trace file (should be in the log folder of your default SQL installation folder) to see if...

Nope

Very nice - Thank you!

the caveat she's refering to is to make sure the work you are doing will not fail for the "little people" who don't run around with sysadmin privilesdges like yourself,...

Lowell (10/18/2011)

---

Doesn't the login takes place BEFORE any session is created, and thus before any rows could exist in sys.dm_exec_sessions?

I think you need something testing ORIGINAL_LOGIN() and

APP_NAME()...

I've been testing a logon trigger that will not allow connection if program name is Ms office. However, I need to allow a couple logins ('sa' and 'Finance') access...

Ninja's_RGR'us (9/20/2011)

---

I agree there can be significant gains. Imagine a system with only 3 GB available to SQL and wasting 1 GB on that cache (I doubt it's possible...

The address below is a good read on the topic:

http://sqlskills.com/BLOGS/KIMBERLY/post/Procedure-cache-and-optimizing-for-adhoc-workloads.aspx

Ninja's_RGR'us (9/20/2011)

---

That's not where I'd start but I guess you're way down on the rabbit whole?

Any proof of memory pressure or io read issues? If not I probably wouldn't...

Just trying to squeeze every ounce of Performance out of my system. Looks like I am wasting about 4GB of memory...