|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Why does MS SQL 2005 Management Studio runs/loads @ a snail pace?Im not sure whether Im the only one facing this issue. Despite that MS SQL 2005 management studio is the only active application running on the foreground, it can load pretty (very) slow. Eg: you right click a table, to go into DESIGN mode - the mouse cursor will turn into an hour glass - few seconds later, the table defination shows up. This simple action can take up to 10 seconds to complete - despite that the table definitation is very minimum. Sometimes you want to commit data changes to the table, it takes eons to commit the data despite there are minimum columns on the table and it doesnt have any relations to other table. In a nutshell, it is slow on my machine. Are there ways to optimize or speed things up? Im running a core2duo 1.7 with 1 gb ram. I prefers the SQL 2000 Enteprise manager though - It is blazingly fast. On Nov 23, 11:32 am, stevong <stev***@gmail.com> wrote:
Show quote > Hi everyone. Hi everyone.> > Im not sure whether Im the only one facing this issue. > > Despite that MS SQL 2005 management studio is the only active > application running on the foreground, it can load pretty (very) slow. > > Eg: you right click a table, to go into DESIGN mode - the mouse cursor > will turn into an hour glass - few seconds later, the table defination > shows up. > > This simple action can take up to 10 seconds to complete - despite > that the table definitation is very minimum. > > Sometimes you want to commit data changes to the table, it takes eons > to commit the data despite there are minimum columns on the table and > it doesnt have any relations to other table. > > In a nutshell, it is slow on my machine. > > Are there ways to optimize or speed things up? > > Im running a core2duo 1.7 with 1 gb ram. > > I prefers the SQL 2000 Enteprise manager though - It is blazingly > fast. Under IE, Internet Options -> Advance - > Uncheck check for server/publisher revocation certificate. and ms sql 2005 mgt studio runs faster. Regards You can also use "-nosplash" switch for sqlwb.exe. It'll suppress the splash
screen so you'll gain 1-2 secs to open SSMS. -- Show quoteEkrem Önsoy "stevong" <stev***@gmail.com> wrote in message news:fdff48c6-2596-4668-9400-37623a6421c7@e25g2000prg.googlegroups.com... > On Nov 23, 11:32 am, stevong <stev***@gmail.com> wrote: >> Hi everyone. >> >> Im not sure whether Im the only one facing this issue. >> >> Despite that MS SQL 2005 management studio is the only active >> application running on the foreground, it can load pretty (very) slow. >> >> Eg: you right click a table, to go into DESIGN mode - the mouse cursor >> will turn into an hour glass - few seconds later, the table defination >> shows up. >> >> This simple action can take up to 10 seconds to complete - despite >> that the table definitation is very minimum. >> >> Sometimes you want to commit data changes to the table, it takes eons >> to commit the data despite there are minimum columns on the table and >> it doesnt have any relations to other table. >> >> In a nutshell, it is slow on my machine. >> >> Are there ways to optimize or speed things up? >> >> Im running a core2duo 1.7 with 1 gb ram. >> >> I prefers the SQL 2000 Enteprise manager though - It is blazingly >> fast. > > > Hi everyone. > > Under IE, Internet Options -> Advance - > > > Uncheck check for server/publisher revocation certificate. > > and ms sql 2005 mgt studio runs faster. > > Regards Good one. :-)
-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Ekrem Önsoy" <ek***@btegitim.com> wrote in message news:8257D21B-C9BD-498B-BF19-7923F8CC17F1@microsoft.com... > You can also use "-nosplash" switch for sqlwb.exe. It'll suppress the splash screen so you'll gain > 1-2 secs to open SSMS. > > -- > Ekrem Önsoy > > > > "stevong" <stev***@gmail.com> wrote in message > news:fdff48c6-2596-4668-9400-37623a6421c7@e25g2000prg.googlegroups.com... >> On Nov 23, 11:32 am, stevong <stev***@gmail.com> wrote: >>> Hi everyone. >>> >>> Im not sure whether Im the only one facing this issue. >>> >>> Despite that MS SQL 2005 management studio is the only active >>> application running on the foreground, it can load pretty (very) slow. >>> >>> Eg: you right click a table, to go into DESIGN mode - the mouse cursor >>> will turn into an hour glass - few seconds later, the table defination >>> shows up. >>> >>> This simple action can take up to 10 seconds to complete - despite >>> that the table definitation is very minimum. >>> >>> Sometimes you want to commit data changes to the table, it takes eons >>> to commit the data despite there are minimum columns on the table and >>> it doesnt have any relations to other table. >>> >>> In a nutshell, it is slow on my machine. >>> >>> Are there ways to optimize or speed things up? >>> >>> Im running a core2duo 1.7 with 1 gb ram. >>> >>> I prefers the SQL 2000 Enteprise manager though - It is blazingly >>> fast. >> >> >> Hi everyone. >> >> Under IE, Internet Options -> Advance - > >> >> Uncheck check for server/publisher revocation certificate. >> >> and ms sql 2005 mgt studio runs faster. >> >> Regards > Another one
Navigate C:\Documents and Settings\urid\My Documents\SQL Server Management Studio\Settings and open with notepad CurrentSettings-2006-01-30.vssettings file . Find AnimationSpeed and change the value to 10 Show quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:e4fnFYbLIHA.1212@TK2MSFTNGP05.phx.gbl... > Good one. :-) > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Ekrem Önsoy" <ek***@btegitim.com> wrote in message > news:8257D21B-C9BD-498B-BF19-7923F8CC17F1@microsoft.com... >> You can also use "-nosplash" switch for sqlwb.exe. It'll suppress the >> splash screen so you'll gain 1-2 secs to open SSMS. >> >> -- >> Ekrem Önsoy >> >> >> >> "stevong" <stev***@gmail.com> wrote in message >> news:fdff48c6-2596-4668-9400-37623a6421c7@e25g2000prg.googlegroups.com... >>> On Nov 23, 11:32 am, stevong <stev***@gmail.com> wrote: >>>> Hi everyone. >>>> >>>> Im not sure whether Im the only one facing this issue. >>>> >>>> Despite that MS SQL 2005 management studio is the only active >>>> application running on the foreground, it can load pretty (very) slow. >>>> >>>> Eg: you right click a table, to go into DESIGN mode - the mouse cursor >>>> will turn into an hour glass - few seconds later, the table defination >>>> shows up. >>>> >>>> This simple action can take up to 10 seconds to complete - despite >>>> that the table definitation is very minimum. >>>> >>>> Sometimes you want to commit data changes to the table, it takes eons >>>> to commit the data despite there are minimum columns on the table and >>>> it doesnt have any relations to other table. >>>> >>>> In a nutshell, it is slow on my machine. >>>> >>>> Are there ways to optimize or speed things up? >>>> >>>> Im running a core2duo 1.7 with 1 gb ram. >>>> >>>> I prefers the SQL 2000 Enteprise manager though - It is blazingly >>>> fast. >>> >>> >>> Hi everyone. >>> >>> Under IE, Internet Options -> Advance - > >>> >>> Uncheck check for server/publisher revocation certificate. >>> >>> and ms sql 2005 mgt studio runs faster. >>> >>> Regards >> > > |
|||||||||||||||||||||||