September 24, 2009 at 12:55 pm
Hi I am in the midst of a project to upgrade many dbases from sql2000 ent, to sql2008 ent. Part of the project I am required to get pre and post performance metrics.
To achive this I am trying to utilize the Tsql replay option . If anyone has any experience with this ( proper events) please advise I am seeing errors and am troubles generating reports.
What I have done thus far is
1: run a sql2000 tsql replay profile trace against dbase A.
2: save it to a table
3: replay it to sql2008 dbase A ( upgraded)
4: save to table
Write sql against both tables trying to get pre and post data(duration)Any assistance would be appreciated.
September 25, 2009 at 12:18 pm
Scalability Experts has a free tool called the SQL Server 2008 Upgrade Assistant. I used it a few times and it does most of what you're looking for. I'd check into it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply