TempDB shouldn't be on C. It should have a dedicated physical drive, due to high usage it tends to get. Raid 1 or 10 if possible.

SQL always hogs memory. That's...

Available memory's a bad measure. SQL will, by design, take memory if it is available and if the max memory has not been set.

Express is limited to 1 GB...

Anyone noticed that this thread is 3 years old?

Hans, can you start a new thread and explain your problem please?

CPU is time spent on the CPU in miliseconds

Reads and Writes are the number of pages (8k) read or written by the query

Duration is the total time taken for the...

Were you testing on the same machine or different? Were the settings of the 2 SQL instances the same?

I can't really offer a suggestion without more info. What did you...

Always, always set the max memory on 64 bit systems with lots of memory. SQL loves memory and will happily starve the OS if permitted.

I've seen my 48 GB server...

To get out of a while loop, there must be a statement within the loop that sets the variable involved in the while condition to...

Same database, same data, same hardware, same queries?

Pleasure

Jeff Moden (7/23/2008)

---

Now THAT sounds like a fun system to be on and that the DBA (you,...

Depends. Do you mean certified as in...

It looks like all the errors are in the nonclustered indexes. I would suggest dropping and recreating all of the nonclustered indexes and constraints on the table 'SyncServerState' and recreate...

Ross McMicken (7/23/2008)

---

The DBA's that specified the 50MB were of the opinion that aproperly designed application doesn't need more tempdb. I was glad I didn't have to deal with them....

Got a backup?

There are cases where CheckDB cannot repair. They're not common, but they do happen. If you run into that your oprions are usally restore a backup (which is...

and more than one independant RAID array.