Hi I'm interested to know more about how optimize for ad-hoc workloads only affects ad-hoc batches, not procedures. I recently noticed that a lot of cache was being used...

Thank You!

--First Create sp_help_revlogin and use it to migrate logins

--Second run this to update the server roles

They're done weekly. I'm actually working through testing ola's scripts on it.

OK that's what I thought. The T-log grew due to a bad query so now it's >1% used. I was hoping I could shrink to reduce the backup...

I'm having the same issue. My sqlservice and agent accounts have full access to the cifs. I can manually browse and create/delete folders while logged on as those...

It's a SQL statement in the field textbox, Google ExecuteSQL. The select statement is:

SELECT serverroles.name

FROM sys.server_principals AS serverroles

JOIN...

Seem legit:

Idera Query[/url]

Good old sql server dashboard[/url]

Add

-namespace "root\Microsoft\SqlServer\ComputerManagement11"

-class HADRServiceSettings

...to the list of Documentation I'm looking for

I should have read first and posted second. Licensing is such a pain.

Ah yes, the two possible answers I was thinking of 😀

...still not sure which is the case. Isn't 2012 core only licensing, no CAL option?

+1, also seeing this issue

Yeah, that "Local server connection" part is a PITA.

Maybe I will just stop using maintenance plans altogether, they seem to be more trouble than they are worth.

Thanks for the comments!

I've been unable to find a way to script out MP's. I do like the extended logging information the MP's provide. The closest thing I've been able to...

its a commvault backup thing

Looks like my issue was a bad hosts file entry...check yours...