Careful:sick:

Here is a sample http://www.sqlservercentral.com/Forums/Topic1380488-21-1.aspx.

Are your packages stored in msdb or on disk?

Since the move is more political and not performance based, sure go ahead and move the db no matter what the performance is.

That said, to make hardware choices more info...

40% CPU utilization is not enough to get me to get a new SQL Server.

If there are performance issues, I would start looking at other things.

If things are slow, and...

For the stored procedure part, you can query sys.sql_modules.

To find which packages touch which tables, you would have to parse the xml of each package or look at the package...

Cody K (6/26/2014)

---

Wow that was a while ago. I did quit, took a month off, took a second month off, and just when I was about to become a normal...

Love it when they change priorities, not day by day, but minute by minute basis. Makes it a lot of fun to decipher what really needs to be done.

My point? Most people watch a lot more television than six hours per week. What do I do with that time instead? I read books and blogs. I "tinker" with...

patrickmcginnis59 10839 (6/26/2014)

---

Probably by...

Bola

With a sliding window?

Should we partition by date? Or something else?

KWymore (6/26/2014)

---

SQLRNNR (6/26/2014)

---

Jeff Moden (6/26/2014)

---

KWymore (6/25/2014)

---

Reminds me of the Oracle error I got the other day -

SQL Error: ORA-14451: unsupported feature with temporary table

14451. 00000 - "unsupported feature...

FWIW, looking at your waits, only 2 stand out.

CXPACKET and WRITE_COMPLETION

You can search on those. But without information about IO load or your disk subsystem I won't comment yet...

just making the link look obvious.

Lynn Pettis (6/26/2014)

---

I will agree to disagree. Just saying, though, Microsoft doesn't always know best how each server (or database) should be configured. Just look at the default...