I would also ask "why was the port made 'dynamic' in the first place?"

If it is on a standalone SQL Server "Why", "Security or some other policy driven reason"

However if...

agreed as it is written - however there are relevant truisms that do enhance performance on truly large systems.

We have found that on NUMA architected 'physical' systems one file...

with 1 TB of RAM one would hope that 'paging' is 99.999% non-existant (the OS will use an very, very, very amount still though).

We have a number of HP DL-980's...

Here is a rather old article from a trustworthy source: http://www.sql-server-performance.com/2006/awe-memory/

SQLServerCentral just a service and I don't care how it works, as long as it does 🙂

one more bit ...

If using an AD account it needs to be in the LocalAdministrators group on the server in addition to the SQL sysadmin role.

This is especially true if...

Be careful in evaluating the move from SQL Express.

Below is some current licensing cost information:

- SQL 2012 'standard' - $1,793 per core, buy in 2 packs - $3,586 -...

Locking/blocking and deadlocks are more application code and database design related.

I asked about the upgrade in HW because it seems that that was the last thing to change - I...

was there a change in the number of CPUs ? did you go from single/dual core CPUs to dual/quad/octo cores ?

I ask because paralellism may be a culprit ...

I would not totally ignore the disk queue length since this is a local array. However a 15 second sample interval is way too long an interval - to diagnose...

hmmm ... unless I missed it nobody mentioned the 'economic decline' that occurred in 2008, its impact and the 'slow' recovery. Prior to Q3 2008 there were monthly catered...

WOW Steve - it seems that you really hit a 'hot' button on this one ...

Jeffrey, Joe and Kevin hit all of the relevant points.

We have a 1.5 TB database filled with 1.2 TB of data. Using SQL LiteSpeed, a good SAN, multiple HBAs and...

Since we are talking about the 'right' things to do for your SAN disks on SQL Server let us not forget to check with you specific SAN manufacturer's best practices/whitepapers...

Depending on whether or not you have a large enough maintenance window reindex is OK (remember reindex locks out the users from the table !). However if concurrency and uptime...