Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 vs SQL Server 2000 Memory Usage Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2014 7:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 4:06 AM
Points: 8, Visits: 44
Hi.
I have some cases here.
I restored a database from SQL Server 2000 to SQL Server 2005.
I allocated max memory in SQL Server 2005 with the same value in SQL Server 2000.
Here are my question:
- Is there any differences in memory usage between SQL Server 2005 & SQL Server 2000? I mean, for the same exact database and application, the performance in SQL Server 2000 and SQL Server 2005 are same or not?
- Is there any specific settings that I must set in SQL Server 2005 when migrating database from SQL Server 2000 to SQL Server 2005?

Many thanks for the answer :)


Andy Chiarwanto Pranata
Post #1545667
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse