General Speed issues....
-
Hi
Does anyone else have a real issue with the speed of the Management SSMS console? I know there's more to it than the old Enterprise Manager but it's almost unworkable.
I've removed the "Check for publisher's certificate revocation option" from IE and this has really speeded up the startup time. But once I'm in there it regularly takes 30 - 40 seconds to do certain things. For example, 30 seconds to hit Edit on a Job step to see the code it is running. Maintenance plansa are another thing that take forever.
This is on brand new installs of SQL 2005 32-bit, SP1 with no-one else on the box.
cheers
-
I've also had troubles with speed with ssms. And I've heard quite a few others complain about that one. However 30-40 secs to edit something, that's way worse than what I was dealing with!!
-
Heh... now you know why I always wait for a couple of service packs to come out before making a switch...
I'm thinking that if your box doesn't have 2 gig of ram, that would probably be the problem. Even EM got a bit doggy if boxed with less than 512K.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
One other thing... Centrino's aren't real good for 2005 (or even 2000). There are a couple of other processors that pretty much suck, as well, but I can't remember their names. Last, but not least, you'll need a healthy amount of disk cache if you really want to make it fly.
Generally speaking, of course
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
So what are you suggesting?
3 gig of ram + 1 gig swap?
-
If you can pack it in, 3 gig would be nice... if you get to the swap file, it's too late.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
The application speeds are fine ,faster than 2000 in most cases so the server isn't really the issue. It's my desktop and using SSMS for general admin across all servers. Don't think they'll give me 3gb for that...!
-
Without even going to 3 gig. Asking fro an extra 2 gig (around 200$) to improve your moral and performance is not a waste of money. Especially if you can prove them that the pc is just too slow for your needs at the moment.
-
If you are the DBA/Senior Developer, they should have no problem with with the memory on your desktop... all of our developers have at least 1 gig and most have 2. Having lots of memory is probably the least expensive method of improving productivety. And, laptops don't cut it as a "desktop" (most of them don't, anyway).
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply