Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Is SQL2K8 SSMS slower than SQL2K5 SSMS?


Is SQL2K8 SSMS slower than SQL2K5 SSMS?

Author
Message
Bubun
Bubun
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 111
We have a DB [MYDB] in SQL2K5 box, we are migrating the DB to SQL2K8 box, hence restored the backup from 2K5 box to 2K8.

I have a question with following query

set statistics time on
SELECT TOP 1000 * FROM [MYDB].[my].[MY_TABLE]
set statistics time off

In 2K5 SSMS it takes around 3000 ms and in 2K8 SSMS it is taking 9000 ms.
Now if I execute the query from 2K5 SSMS for both the DB then execution in 2K8 DB is less than 3000 ms
and if I execute the query from 2K8 SSMS for both the DB then execution in 2K5 DB is more than 9000 ms

What could be the reason? Is there any feature I need to disable in SSMS 2K8?
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17569 Visits: 32254
Are you capturing the execution plan in the 2008 version of SSMS? Make sure you have the latest service packs installed on your server and on your client machine. Check the default settings for connections on both to ensure one isn't different than the other. After moving the database, you need to update statistics. If not, they get updated manually. Try updating them with FULLSCAN on the 2008 server to ensure you've got the best possible statistics. Not being there it's hard to know, but no, I've never seen any differences in execution time for queries run from 2005 or 2008 versions of SSMS.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Bubun
Bubun
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 111
Updated statistics with FULLSCAN, but no improvement. My question is why the query taking more time while executing locally in SQL2K8 SSMS than executing remotely from SQL2K5 SSMS?
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17569 Visits: 32254
By default, all things being equal, it shouldn't be taking longer with 2008 SSMS. So, you have to figure out what's not equal. Again, are you capturing an execution plan? Do you have different connection settings, the ANSI settings? There has to be a difference somewhere.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search