shirish_padekar (12/16/2015)

---

We have SQL Server 2012 and I found that we were using sa user in our application's connectionString. Now, we are thinking to replace it with Windows Authentication like...

The trick is going to be identifying what is causing the so much CPU to be used. Since you're just getting started and you're on 2008, the best approach is...

A simple way? None that I'm aware of.

I did a search. The script documented here comes up pretty frequently, but it's anything but simple.

Looking at Paul's script, I'm pretty sure...

What are the actual wait metrics? Check sys.dm_os_wait_stats before, during, and after the issue. Also, look to sys.dm_exec_requests while the issue is running to see active waits. You need to...

Actually, yes. Look down to the links in my signature

|

|

V

THIS!

Scans are not necessarily...

xsevensinzx (12/14/2015)

---

Not to side track, but question:

Why prove the usefulness of R to the DBA as opposed to a general purpose language like Python that can accomplish the same thing?...

It's down to disks and controllers. If you're separating storage onto multiple physical locations (and I use that word because if you're on a SAN, using LUNs, and those are...

Dougieson (12/14/2015)

---

If I'm not mistaken, 2014 removed the restriction of AG being only available for Enterprise Edition.

So, if we can safely assume you are using SQL Server 2014 (cause you...

I do feel for the person. They seem so desperately over their head and quite ill-equipped to deal with that fact, let alone all the other crap that's coming their...

1) Yeah, possibly. Hard to say without seeing the execution plan and wait statistics. I'd for sure collect those to understand what's happening here.

2) No, the COUNT(*) is a fine...

Check the error logs on the primary and the secondary to see what the issue is. Look to the wait statistics on both to understand if it's just a simple...

I'm with Perry. AG is superior in every possible way except the licensing costs.

shamshad.ali (12/14/2015)

---

Can you please short list this? Can you recommend anyone out of your given list?

Sorry for asking this, as I wanted to get the idea from those who used...

Start with the logs. Why is the Log Reader failing? Without...