July 18, 2003 at 6:06 am
Hi. Server is a Proliant ML370 G2, 1.2 Gb Mem. 1.2 Ghz Processor.
I have often problems when I want to expand something like databases in the enterprisemanager (on the server itself). When I want to do the same through the computer management screen it works a lot quicker. Also like asking the properties of the instances.
Anyone has any idea what's going on ? It's SQL 2000, SP3.
Kind regads
El Jefe
JV
JV
July 18, 2003 at 7:06 am
I'm not sure what the computer managment screen is but in general EM is slow. it issues several queries and uses DMO objects to pull back everything it needs and it takes time its also subject to blocks like any other query run on your server. As an administrator I use EM as little as possible.
Wes
July 18, 2003 at 10:08 am
They both use the same controls. However once things are loaded in EM, they will be quicker in Computer Management. I suspect that the MMC for computer management might pre load some things, but AFAIK, these are the same snap ins.
Steve Jones
July 20, 2003 at 10:06 pm
Hi,
Please Check whether you have applied all the service packs.microsoft has confirmed this to be problem in SQL 2000.where the database list loads slower in Enterprise Manager.even i was facing the same issue.once the SP's were applied this problem was overcome
Cheers,
Anees Ahmed M
July 20, 2003 at 10:17 pm
Hi,
Sorry Could not add the Knowledge base article on this in the previous post.this is what microsoft has to say about this.
http://support.microsoft.com/default.aspx?scid=kb;en-us;282416
Cheers,
Anees
July 21, 2003 at 3:14 am
Hi there,
I've had the same problem and I'm on service pack 3A and it still hasnt got any better!
Rolf
July 21, 2003 at 3:29 am
In fact its even worse now with service pack 3a, it also occurs when I alter a tables design or add a column and EM crashes out! Its very frustrating.
Rolf
July 24, 2003 at 3:02 am
I've got the same type of problem.
To solve this problemI had to put into the PATH environment variable the path of the SQLServer binaries C:\Program Files\Microsoft SQL Server\MSSQL\Binn
Bye
Gabor
July 24, 2003 at 7:32 am
Tried this. Put in the bin path into the PATH environmental variable on my win2K box and it now seems to be better.
Cheers
Still weird though!
July 25, 2003 at 7:12 am
if it works it works. I would have never thought to do that.
Wes
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply