MSSQL Compatibility modes

Support for Micosoft SQL Server in the context of Jiwa installations.

MSSQL Compatibility modes

Postby Mike.Sheen » Thu Jun 04, 2009 7:27 pm

Running SQL 2008 or 2005 ? Did you upgrade from a previous version of Microsoft SQL Server at any time ?

If you answered yes to both of the above questions, then chances are you aren't getting the most out of your SQL Server in terms of performance and features.

Fortunately, a single setting needs to be changed to remedy this.

When you restore a database on MSSQL, if the backup was from a prior version, then that database is automatically placed into a compatibility mode with the original version. This was a defensive move by Microsoft to make sure upgrades had no nasty side-effects. However, there are quite substantial performance gains to be had by running the database in the same compatibility mode as the server.

To check the compatibility mode, the easiest way is to open management studio, right click on the database in question, choose properties and you'll be presented with the database properties dialog.

Choose the Options page on the left, and thn you'll see the Compatibility Level as per this screen shot :

Image

If the level does not match the SQL Server version, then change it so it does!
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755

Return to Microsoft SQL Server

Who is online

Users browsing this forum: No registered users and 1 guest

cron