This might help: http://www.brentozar.com/archive/2014/03/finding-one-problem-query-extended-events/

Basically find the execution plan and track that.

You restore msdb if you need your jobs, alerts, operators back. It depends on your instance if you need/want this. Restoring master will recover your logins, but it also sets...

Ha, no worries about me. I get ya'll are scared. It's OK. I won't beat any of you too badly.

arkadiusz.stasiak (9/3/2014)

---

I see no paragraph about "High VLF Count". Was it missed by you, Steve?

And there is a small "bug" in the table with new Autogrowth values - for msdb...

I was there. Taking a break from painting my shed

DavidL (9/2/2014)

---

All good advice. I like the first one (there is no plan), and the part about being true to yourself. It was only after about 20 years...

The reason dropping and recreating the column is marked as wrong is because it says

"You must drop and recreate the column with the PERSISTED attribute"

That is incorrect. You can...

How in synch do you need it? Log shipping will be a pain with the users disconnecting, so I'd look at replication as suggested by Gail.

Apparently lots of people are on holiday at RG, so things moving slow.

I think football season has caused issues, though I'm keeping an eye out.

I may spend some time...

Best you can do is check stats date update.

http://www.sqlservercentral.com/Forums/Topic1115156-391-1.aspx

However, I'd agree with PearlJammer1, the date isn't important. What's important is are the stats up to date in terms of your...

select cpu_count from sys.dm_os_sys_info

That's what SQL Server sees. Should be in the error log. SQL should use all available.

Or do you mean the percentage of CPU by core as an...

It better be Wed. My flight home is Thur and I have to be in San Jose Sat.

It filled up quickly. We should have pulled today's announcement, but things were...

The point isn't that you log everything to a central location for all debugging, but that you integrate into a management system that's being watched. If you don't have one,...

You can use the PIVOT command as well, but I'd recommend crosstabs, as Luis showed.

yes, separate pieces. Some thoughts on why/how you built them and what they accomplish in your mind would be great. Nice to have a setup for testing. I am thinking...