>>Think "compound interest".

Think "read my post"! 😀

The default data file growth is ONE MEGABYTE, not TEN PERCENT (at least on all the servers I recall installing). ...

Blake, you should consider disabling hyperthreading (you mentioned 8 physical, 16 logical cores). HT often leads to worse performance not better in SQL Server environments. Test with your...

Jeff: Don't ever let the defaults for auto-growth on a database occur... it takes 73 disk fragments just to reach 1GB using the default settings.

I believe you are way...

Two very important points:

1) having multiple files for the log is just plain bad practice. Do not do that.

2) You said multiple files on the same drive in the...

bcronce (10/1/2008)

---

I get this issue quite often with the data I work with and I've found doing an update statistics helps in most cases. SQL randomly estimates the 1 row...

1) cost

2) complexity

3) may be sql server only app (although doubtful)

4) ease of development

5) did I mention cost?? 😀

If the database (or at least the tables of concern) can be unavailable for a while I would recommend a drop/create cycle since it seems you have never done index...

What version are you on? I would recommend testing and moving to SP2 + Cummulative Update 6 (or perhaps CU8). There were a BUNCH of regressions in the...

Let me add my recommendation to the other two about getting professional help. You have absolutely no chance of success in this endeavour. There are only a handful...

I highly recommend the free Performance Dashboard.

1) is affinity masking being used?

2) is the batch job query(s) limited in parallelism, either explicitly or by maxdop setting or cost threshold for parallelism?

3) do a simple test while...

blogs.msdn.com/sqlprogrammability/archive/2007/06/29/detecting-overlapping-indexes-in-sql-server-2005.aspx

blogs.ameriteach.com/chris-randall/2007/8/15/sql-server-2005-detecting-overlapping-indexes.html

http://blogs.msdn. com/mssqlisv/archive/2007/06/29/detecting-overlapping-indexes-in-sql-server-2005.aspx

http://blogs.msdn.com/mssqlisv/archive/2007/06/29/ detecting-overlapping-indexes-in-sql-server-2005.aspx

Amazing what a very simple web search can do for you.

I can think of another "pain point" to SYNONYMS - someone (as in me, a consultant) having to step in and debug/tune the queries that use synonyms. I absolutely...

Colin brings up a good point. Have you verified that your memory configuration is correct given that you have 32 bit sql server EE with a large-ram box? ...

Isabelle (9/18/2008)

---

colin Leversuch-Roberts (9/17/2008)

---

I'm going to ask what I normally ask - do you have problems with waits and schedulers and are you monitoring them so that you see this...