| Author |
 Topic  |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
 Posted - 25 November 2002 : 18:32:17
|
| Just installed SQL 2000 (eval) only to find that the new version of Enterprise Manager is slower than the old v7 EM?? Can I change some settings to speed things up a little? |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
Edited by - ruirib on 25 November 2002 18:33:44 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 25 November 2002 : 19:20:06
|
| I believe that there was a service pack or patch for SQL Server 2000 that fixed this problem. |
 |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 26 November 2002 : 06:51:06
|
Ah, I tried to install Service Pack 2 but it choked because is it was only an eval version of SQL 2000. I'll try to look for an individual patch, thanks. |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 26 November 2002 : 06:53:52
|
| I don't believe any of the available SP's or patches will let themselves be installed on an Eval version Im afraid. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
David K
Junior Member
494 Posts |
Posted - 26 November 2002 : 06:57:22
|
I know that it is technically possible to upgrade the server on Evaluation version, but I'm not sure whether the teechnique is leagel.
There is no individual patch.
If you would like more information, email me at davidk@dudy.mine.nu |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 26 November 2002 : 07:47:02
|
Here's how I managed it:
Install SQL server 2K eval(but only client tools option)
Install SQL server 2K Service Pack 2.
It seems that Service Pack 2 only chokes if you install the actual server components.
Hopefully, EM is faster now... |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
|
|
|
David K
Junior Member
494 Posts |
Posted - 26 November 2002 : 07:48:25
|
| It's not faster, it's unchanged, the change is in the server itself! |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 26 November 2002 : 08:21:14
|
I didn't realise you were talking about a remote server else I'd have said that its not an EM problem its actually a server issue which is what the SP2 corrects (well partially anyway, it still happens on some screens in EM with a remote server with a large number of users).
The more users and various permissions set on the DB Server the worse the problem gets, tell your host to get rid of half the databases (except yours) that ought to speed it up a bit. |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 26 November 2002 08:22:32 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
|
|
David K
Junior Member
494 Posts |
Posted - 26 November 2002 : 09:46:25
|
It's not a remote server, it's a local one [qoute]Just installed SQL 2000 (eval)[/quote]
And I already said it's a server and not a EM problem!
I installed SP2 on my server and everything works much better, but it's very hard(and COULD be illeagal) to install on the evaluation version of the SQL server!
If you want more info, email me, or post here. |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 26 November 2002 : 10:08:58
|
Sorry everyone, I should have included more info.
All I need on my local system are the client tools. I then use these to connect to my clients databases wherever they may be hosted remotely.
Actually, after the SP2 update, it seems a lot better. |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
Edited by - D3mon on 26 November 2002 10:16:49 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 26 November 2002 : 18:36:14
|
| I thought it was Remote :), my understanding is that patch mainly changes some server behavours, there must be something in EM it patches as well then if you are seeing performance increases :) .. main thing is its better I guess. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
| |
Topic |
|
Topic Locked
