if you use BOL (a MARVELOUS resource!), it will explain the max memory setting.

Not sure why it took all of those posts to get to checkpoint as the likely cause!! 🙂

You could test this by setting the recovery interval to a very...

dbcc checkdb can repair some things - see bol. Make sure you have a backup first.

sometimes suspect status can be reset.

call microsoft technical support

apexSQL log may be able to...

1) are your columns char or varchar?

2) did you create the index EXACTLY as suggested - i.e. INCLUDE the other 2 columns??

3) Full-text may not help here either...

I am 98% certain that the problem is poorly written queries and/or missing indexes. In profiler, trace just these two: Stored Procedures: RPC Completed and TSQL: SQL:...

nKognito (5/13/2008)

---

I do not have any bottlenecks right now. All that I want is to understand is there any simple way to improve SQL server performance and throughput by adding...

>>Direct attached storage isn't an option, as it's a clustered server. Also corporate policy states all servers will use SAN storage. <<

The first statement is a wive's tale. You...

nKognito (5/12/2008)

---

Thanks for your replies! I will check every suggestion. One more question: what do you think about technology that called linked servers - can it improve performance and bandwidth?...

1-2ms for log writes. Anything > 5ms is probably trouble.

8-10ms for various and...

Marios Philippopoulos (5/8/2008)

---

I'm also experiencing difficulties convincing our SAN people that RAID 5 is unacceptable, especially for tempdb.

Also tempdb data files need to be on their own dedicated physical device.

I...

Per this post from a Microsoftie, there were patches for both SP1 and SP2 related to ghost cleanup:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2397281&SiteId=1

-T661 turns of the ghost cleanup. It is used in TPC configurations. THIS...

Fundamental tenet of database performance:

1) find bottleneck

2) fix bottleneck

3) goto 1)

I would be willing to bet a steak dinner that your performance can be improved (probably much more...

Since this is a 2005 specific forum, I think it is best to use this: sys.dm_io_virtual_file_stats

Lynn Pettis (5/8/2008)

---

From what I have read, creating multiple files for tempdb helps even if they are on the same drive. I have a production server setup that way...

Lynn Pettis (5/8/2008)

---

Properly used, UDF's good; improperly used, UDF's BAD.

Comes down to an "It depends".

I have a set of tvf that allow me to do As Of queries against our...