May 13, 2010 at 10:45 pm
We are in the process of Migration from Sql 2000 to 2005 I have took backup from sql 2000 and restored in 2005 then i changed the compatibility to 90
Now i need to the database is fine tuning.
As a DBA how to finish this tasl
i have a database size 6GB (850 Tables in the Database)
u r replies will be higly appriciated
Thanks in advance
May 13, 2010 at 11:04 pm
That is a very broad question.
Start by finding your queries that are performing poorly and optimize them.
Load test the server
Have somebody perform applications testing against the database to ensure no bugs were created due to the upgrade.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 14, 2010 at 12:04 am
looked for all the build-in system functions and query types (joins) used in previous version and confirm if they still work in newer versions.
3.Pulled all the datatypes used in previous versions and map them to new version's datatype - it will mostly match. Also, checked if you use newer datatype for better space and performance behaviours.
Created some handy scripts that can make couple of things faster and easier like login migration, after migration health check script.e.g DBCC Commands.
5.The helpfull tools in the process is profiler and its re-play functionality. Capture all the queries that run on previous version and test replay them in new version's test environment and go on fixing the queries that are having trouble with.
Thanks
sandeep
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply