As an FYI, versions of SQL which are Express only use one core. This is the major reason that non-Express versions out perform Express versions, other than the memory increase.

Due to the one core usage if there are multiple users querying the database at the same time, then there can be performance degradation.

One should also be sure to have the latest Service Packs.

If the new ICD-10 codes are causing issues with certain screens, then we can find out on ways to tune it provided we have SQL Server Standard or Enterprise edition.

Change to SQL Server Standard is not a plug and play operation. The only thing I don't know is when you upgrade, if it is no issue.

I have also noticed new databases in the AC chart. I have no idea if this has anything to do with it.

PartnerTranactions.mdf and Log.log

CAN SOMEONE LOOK AT THE MOST RECENT VERSIONS GOING BACK THROUGH THE 8.0S TO THE 7.0S AND SEE WHEN THIS CHANGE TOOK PLACE.

I can then look into that.


Bert
Pediatrics
Brewer, Maine