Lots of people here have thrown out the DBA Architect roll. But I don't know that most Sr DBAs have what it takes to move into that roll, especially...

There are more and more companies offering production dba support as a service. Thus I think this class of employee will be less in demand with laid-off types bloating...

Mohammad Irfan (7/2/2008)

---

Cant do anything on...

Does this server have a non-default max memory setting? You should do that for every server, and it will probably prevent the issue you are seeing.

In given case it isn't a datatype declaration, just not using the correct type due to the cast. I assume you were doing 101 convert to remove the time...

Another very good thing to look for in query plans is low estimates with telephone numbers for actual rows.

My first cut at a profiler run at a new...

I'm hoping that this 'bad query' was the culprit in the performances issues I was having - it would have been running on the morning of my attempted server switch....

I will just point out 1 thing here (not much to add since we have essentially no details to offer advice on thus far) is that a logical IO doesn't...

1) In general the optimizer is much better in 2005 than 2000. However, there were a BUNCH of regressions - queries that perform slower on 2005 than 2000. ...

zach_john (6/27/2008)

---

Did you run a perfmon and look at the average disk read queue length for each drive? The Average here should be under 2, if it's not look to...

Personally I think this is a time to call Microsoft Product Support.

At each of my last 3 SQL 2005 performance tuning/analysis client gigs I have addressed tremendous performance issues by removing the use of TVFs (and also table variables). It...

jim.powers (6/26/2008)

---

TheSQLGuru (6/26/2008)

---

I would like to add that it has been my experience that SAN vendor consultants know VERY little about how to optimally configure a SAN for SQL Server...

I still submit that the most cost effective thing you can do is hire a decent perf consultant for a limited tuning analysis engagement.

Glad performance improved. It is simply amazing how often IO is the cause of poor database performance.

My quickie review of your perfmon reveals the following:

1) Avg CPU is pretty...