The keys from the original post were that it was repeating every so many minutes and the period...

dsc (5/13/2008)

---

Hello everyone,

we have one heavy busy database. I was able to prove that we could do 7 times the current load. But then the SAN is very busy at...

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