Oh boy.  Here are my Christmas presents.

1. Developer requests a service account for an ETL process. SECURITY takes it at face value, and creates one account and grants it permissions...

When you say the VM has been checked, can you elaborate?  This really smells like VMWare ballooning resources.

There are a couple things in your post that may need more clarification:

Task manager is showing the SQL Server process at close to 100% so it doesn't seem to...

Installing the various iterations of SSMS has required a LOT of research.  Until we disabled the "A new version is available" popup, diagnosing issues caused by the users installing the...

Jeff, thank you for that information. I will research.

So we are using the Hallogren solution for index maintenace and yes, it involves reorgs. I removed reorgs from the servers...

Stop rebuilding indexes.

Microsoft's documentation states:

Index maintenance decisions should be made after considering multiple factors in the specific context of each workload, including the resource cost of maintenance. They should not...

Show your code, ol' friend, so that people don't just look at...

Not Burgatory! Ed and Jeff will murder me!

The last time...

Your google search will return the same results as mine.  You will find blogs and articles about this that conflict.  Brent Ozar and Paul Randal have written a lot of...

What is there to be confused about?

You have two servers, and two accounts. One is a sysadmin on one server, the other is not.

Sysadmin is the highest level of permissions...

I am really curious what the use case is for being able to store values this large???

What actions have you taken...

Unless you re-start, it's not going to clear the old files up.

And honestly, I'm not sure I have ever set this. I have sp_cycle_Errorlog set up in a SQL job.

Back, barely functional after a few airplanes, but I see your complaints and have forwarded them on.

I don't know what I can say or do and I'm fairly...

Hey All,

Steve's on the road in Australia, so I'll let him respond here when he gets around to it. I just wanted to let you know why you might...