I think that organizing by version and function is the best way to approach this, however I think that the submission process is where the most benefit will be had.

Instead...

Andrew Barton (12/31/2008)

The blocking only occures after the procedure cache drops. Fixing the...

you can use DATALENGTH to get the size of an existing record, not sure how you would handle a new one. Trigger or Indexed column maybe?

SQL could...

What sizes are your partitions?

It might be worth going with 2 x RAID1 sets and move your log files on to another physical RAID set. This would dedicate spindles for...

Oh, and have you identified the root cause of the blocking? Where it all begins?

Dang, that's pretty brutal.

Do you have any particular process that executes at the time that you see the cache drop off?

Have you considered running a perfmon for the SQL instance...

Perry Whittle (12/31/2008)

Dugi (12/31/2008)

Yes I can see for that reason I told Steve that the SSC board should...

Incidentally, I prefer to use Putty myself, psftp is a lot more solid, and also has full SSH capabilities for secure ftp processes.

ftp

user:

pwd:

lcd

put

bye

Check out http://www.nsftools.com/tips/MSFTP.htm for all the commands.

1) Check your event logs (system and application) from errors

2) Check your hardware (reseat the memory and look for any hardware issues)

3) Run another checkdb on every database

4) Call Microsoft...

You need to recreate the index.

Please see the thread at http://www.sqlservercentral.com/Forums/Topic301624-146-1.aspx which describes a similar issue.

You need to contact Microsoft Product Support. That kind of problem is something that really needs to be handled at their level.

Can you define slow? Slow in what fashion? Inserts/updates/queries?

Is it general slowness, or at particular times?

How large are the databases and tables?

What's your disk subsystem, and how are...

Sorry, I should have clarified the "pinned" reference. It was a semi-sarcastic comment, something that puts any SQL skills I have to shame.

http://www.mssqltips.com/tip.asp?tip=1317