Home All Groups Group Topic Archive Search About

Why does MS SQL 2005 Management Studio runs/loads @ a snail pace?

Author
23 Nov 2007 3:32 AM
stevong
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.

Author
23 Nov 2007 7:09 AM
stevong
On Nov 23, 11:32 am, stevong <stev***@gmail.com> wrote:
Show quoteHide quote
> 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
Are all your drivers up to date? click for free checkup

Author
23 Nov 2007 9:30 AM
Ekrem_Önsoy
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



Show quoteHide quote
"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
Author
23 Nov 2007 9:48 AM
Tibor Karaszi
Good one. :-)

Show quoteHide quote
"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
>
Author
25 Nov 2007 11:35 AM
Uri Dimant
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
>>
>
>

Bookmark and Share