You may have plan cache bloat. Glenn Alan Berry has some Diagnostic scripts for 2008 that can show you single use plans and lots of other stuff. I...

ksr39 (8/7/2012)

---

Thank you all for your replies …

Actually I have no idea about a DB or Server Health Check mean, I was expecting a script which can give me a...

Jason-299789 (8/7/2012)

---

Thank you to both of the replies so far its confirmed a few things, and given me a few things to ponder.

The PK is Non-clustered on the #Lookup table,...

Here is a good set of scripts to use: http://sqlserverperformance.wordpress.com/2012/06/12/sql-server-2005-diagnostic-information-queries-june-2012/

BUT you need to know a bit to INTERPRET the resulting outputs. MUCH better is to hire a professional...

gheinze (8/5/2012)

---

Hi all, i cant think about an apropieted subject for the topic.

Here is the thing.

We have a Server with this specs

Windows Server 2008

8 x Intel Xeon L7555

32 GB Ram

RAID...

First off...

1) I hope you updated ALL statistics (index, column, etc) with a FULL SCAN immediately after upgrade. That is a MANDATORY step.

2) Most tuning will come exactly like it...

erics44 (7/30/2012)

---

ha, i wish

i wouldnt know where to start to pick appart the existing code in the sql databases

the most annoying thing...

1) I recommend to all my clients to actually SIZE their files to allow for 12-18 months of EXPECTED database total size IN ADVANCE and then monitor monthly. An...

1) the "disk" configuration you gave us is almost useless from an "is it configured well" perspective because you gave us no idea about the underlying IO subsystem configuration other...

sp_whoisactive is a great option too. you can find the latest version (11.11 last I heard) on sqlblog.com.

GilaMonster (7/18/2012)

---

b.hedge (7/18/2012)

---

Found out that all Log file LUNs for multiple server were stored in the same disk group and was ~75 % subscribed. They also bypass cache and...

import/export wizard is easy to use and certainly fast enough to handle 30M rows.

A picture is worth a thousand words. So I like to use a good modeling program (Embarcadero's ERStudio is my favorite by a long shot), which not only offers...

jfriedl (7/16/2012)

---

well I don't have CLR and would prefer to not do anything with cursors, so what I will do is load a history table with all data prior...