GilaMonster (8/8/2014)

---

Wrong question

SQL will use all the memory that it's allowed to use, up to 100% of what's on the machine. You need to set its limits. If you don't,...

I think this is slightly mis-stated Jeff. While you may not get fragmentation from end-of-index inserts, you certainly can get page LATCH contention, which can be a significant bottleneck...

Robert klimes (8/7/2014)

---

So now...

Roger Sabin (8/7/2014)

---

Is there any way to "prove" that the issue is a data skew problem? This is a production system so I can't just play with trying to force...

Roger Sabin (8/7/2014)

---

I always thought that parameter sniffing problems had more to do with ranges than with direct seeks.

If it was a parameter sniffing problem then shouldn't I be able...

While you are figuring out what you really want (and scripting sample tables/data for us to help you better), search the web for sql server CASE pivot and see if...

I strongly recommend you bring Allan Hirt (http://sqlha.com) on board to help you understand what your options are, what you need and how to get the two to match up....

Perhaps what you are observing is simply an artifact of the AG normal operations? Perhaps BOL and blog posts just haven't caught up with that yet? I honestly...

Review this and any follow-on posts, being sure to review all the DMVs for various LSN values and states on primary and secondary: http://blogs.msdn.com/b/alwaysonpro/archive/2013/09/27/performing-transaction-log-backups-using-alwayson-availability-group-read-only-secondary-replicas-part-1.aspx

Hopefully you can figure it out...

I'm gonna be blunt here, so don't get offended but DO listen. HA is a CRITICAL part of a business' ability to function. If you screw it up...

Triggers fire PER BATCH, NOT PER ROW!! If an action in SQL Server affects 100 rows every trigger you create MUST be able to process ALL 100 rows -...

Since you have already been hacked, you must assume that your ENTIRE hardware infrastructure is compromised, especially if you are like most of my clients and run your stuff with...

1) With SQL Express you can get hit by the 1GB memory limit AND the one CPU limit too.

2) File IO stall analysis can tell you how much...

I also note you are comparing a desktop OS to a server OS. And 32 bit vs 64 bit. Virtualized too by any chance? Did you update all...

SQLSlammer-133701 (7/23/2014)

---

I hope this doesn't get viewed as a thread hijack..but TheSQLGuru.

If you are updating stats more than once week, at what point do you update stats with FULLSCAN? or...