Jon.Morisi (4/30/2013)

---

Let me rephrase. I'd like to determine the cost benefit of each statistic on my table. If it's costing a lot to maintain the statistic and not...

Also worth taking snapshots of waiting tasks during these runs. It could bring up resource names that force everything else to wait for.

If there are many active spids but just...

You could also play with the thresholds - I also use Ola's defrag scripts but set them to take it easy on re-organize and just go for full rebuild when...

With no specifics we're all shooting in the dark here, but if it stays 'processing' for days and you have no obvious way to tell what it's doing, it may...

TF8015 - never thought to use it on modern machinery.

Would it disable NUMA detection at startup and make all memory access appears as 'foreign'?

Hey,

I almost fell for it - went to my TraceFlags list to check 'how on earth have I missed this one!'

It was a good April Fool's post, get over it:-D

'online on another server'

Does this mean you are querying through a linked server?

If so, you need to ensure that the account used can see the statistics of the remote objects...

I remember Paul Randal mentioning during a presentation recording at least one financial institution going out of business due to their systems being unavailable for several days (regulators place tight...

Nice one, almost got me there :hehe:

I'm thinking of using this flag and I'm looking around for meaningful feedback.

Hadn't seriously considered it before because I thought it was only meant for new servers with 10 or...

If you suspect that you may be cutting it too close memory-wise, it might be a good idea to capture some perfcounters regularly (say every few minutes at least) and...

'lopsided' is my diplomatic way of saying : WTF dude 😛

2-4GB per core I've found to be a half-decent rule of thumb for many workloads.

Depending on code quality I may...

As a side-note, 12 CPUs and 4GB of RAM does seem a bit lopsided.

If it is a modern-enough server (2 sockets of 6 cores perhaps?) then surely it can take...

Also worth keeping in mind that username, computername can be spoofed.

If it is essential that these are properly audited, I wouldn't trust blindly what the connection details claim 😉

GilaMonster (3/6/2013)

---

SQLCharger (3/6/2013)

---

My tests have shown a performance degradation when the same queries run on compressed tables compared to uncompressed.

I know, there are fewer pages to trawl across, but it...