Jeff Moden (7/13/2016)

---

paolobianchi (7/13/2016)

---

Hi all,

i have a problem on an application.

Details:

Table AAA, about 500 records, not growing

Many users (about 100) make a read from this table, many times (about 120...

TheSQLGuru (7/13/2016)

---

One thing you kind of have control over is indexing. If a FK'd table is being updated and that is locking your other table and the update is doing...

Eric M Russell (7/13/2016)

---

It could be that the sessions performing updates on this table as part of a larger batch transaction. Often times programming will begin a transaction, update, and...

Hello,

thank to all for precious tips.

I run whoisactive and i get 2 update, one of 19sec!

The type of lock is (19860ms)LCK_M_X

This query (call it UPDATE1) was locked from another query,...

ChrisM@Work (7/13/2016)

---

Is the UPDATE always followed by a SELECT of the new values?

UPDATE [cpwarn] set [autonum] = [autonum]+@1

WHERE [tablecode]=@2

SELECT autonum, tablecode FROM cpwarn WITH (NOLOCK)

WHERE tablecode='prog\DONUMREG\''001''\''2016...

Grant Fritchey (7/13/2016)

---

For such simple queries, there's not much in the way of tuning opportunities. The SELECT query is TRIVIAL, which means that there is only one possible execution plan....

they seems identic to me, but ok, take the actual execution plan 🙂

voilà 🙂

thank you

Paolo

Hello,

thanks to everybody

Changed the setting, no problem with cpu overloading.

After a few hours, situation of cached plan changed...

Before,

CacheTypeTotal PlansTotal MBsAvg Use CountTotal MBs – USE Count 1Total Plans –...

Hello,

thank you for the tip, my only fear is about changing setting in prod because people almost always work on it and i don't know if changing it can, temporary,...

https://www.microsoft.com/it-it/server-cloud/pricing-and-licensing.aspx

Thanks to all.

I found on Microsoft the answer, i MUST licence all core

•To license a physical server, you must license all the cores in the server with a minimum...