The update of the stats for all databases lasts for 20-30 seconds. Except Schema locking, no other locking is put on tables, and that is satisfying.

I see the app queries...

This doesn't work for Standard edition of SQL Server.

+1

GilaMonster (12/4/2014)

---

Page latch, don't know, would need to see the exact resource.

The latch wait is related to parallel table scans. Tune your queries to avoid large table scans running in...

GilaMonster (12/2/2014)

---

So you have procedures running very often, doing a lot of reads from memory...

Again, what is making you think there's an IO-related problem here? You're talking about getting SSDs,...

GilaMonster (12/2/2014)

---

Identify the problems that you're having, pinpoint the causes and address those directly. Just throwing hardware at the problem may well have no effect or may make whatever problems...

You're right. I should devote more effort on the objects' executions. However we...

GilaMonster (12/2/2014)

---

So you have procedures running very often, doing a lot of reads from memory...

Again, what is making you think there's an IO-related problem here? You're talking about getting SSDs,...

Many stored procedures are using temp objects, and their execution count is too high. Some have...

DBA From The Cold (12/2/2014)

---

Hi,

I would have thought that if you are using tempdb heavily, placing it on a faster IO subsystem would improve performance. But how much? I...

Or, ... Does someone think it won't bring significant improvements considering the big enough RAM? Every attitude is welcome...

Thanks

Jack Corbett (12/1/2014)

---

I always point people with MaxDOP setting questions to this KB Article to start with. It sounds like in your situation with only 4 cores...

Sean Lange (11/19/2014)

---

Igor Micev (11/19/2014)

---

Sean Lange (11/19/2014)

---

Igor Micev (11/19/2014)

---

Sean Lange (11/19/2014)

---

Great question on a great topic that many people don't know about.

It makes sense if you think about it....

Sean Lange (11/19/2014)

---

Igor Micev (11/19/2014)

---

Sean Lange (11/19/2014)

---

Great question on a great topic that many people don't know about.

It makes sense if you think about it. How would the 208...

Sean Lange (11/19/2014)

---

Great question on a great topic that many people don't know about.

It makes sense if you think about it. How would the 208 database know that the...