|
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 quoteHide 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 quoteHide 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 quoteHide 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 quoteHide 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 >> > >
Other interesting topics
Copy views from one database server to another
Optimizing and shrinking large highly-transactional database Update Timeout and indexes Trigger to fire only after a commit. SQL server - cant see new backuped base Regarding Transaction Log Is the same? HT sp_help_jobschedule results? Logging from SP Event 18454 connection non-trusted |
|||||||||||||||||||||||