dbTalk Databases Forums  

Bad performance in Management Studio 2008

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Bad performance in Management Studio 2008 in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
LarsJönson
 
Posts: n/a

Default Bad performance in Management Studio 2008 - 04-23-2010 , 07:43 AM






Hi!
I just moved my development environment to a new laptop (i7 2.66 GHz, 8Gb
mem) in Windows 7 Pro x64.
A simple query in SSMS now takes minutes instead of a few seconds. And the
ssms eats memory during the execution.
Exemple:
SELECT TOP 100 * FROM ORDR
Takes 41 seconds and ssms process increase allocated memory from 43 Mb to
555 Mb.

What is wrong?
--
Regards
Lars Jönson

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.