Hi all,
I have a strange performance issue on one of our developer stations. This
station is Trad Chinese WinXP Pro with SQLServer 2000 Dev Ed installed on
it.
The problems are:
1) The tools (like QA for instance) cannot connect to other SQL Servers on
the network.
2) EM will take at least 1/2 minute to do any task. Any task like expand
the Databases tree to show all the databases... or ... expand one of the
databases to show the items(tables, storedproc, roles, etc) for that
database .. or .. expand the tables tree to show all the tables ... etc
This is a major problem since item 1 prevents this developer from testing
against another SQL Server. And, at the same time item 2 prevents the
developer from testing against his own local test server.
I have tried all the common things:
1) Reinstall SQL Server (and Client Tools) on this station
2) scan the disk (for lost clusters and such)
3) remove temp and other useless files
4) defrag the disk
Even the EM itself seems to repaint its windows slowly .. you can actually
see the drawing process.
The computer can otherwise access the network .. and no slow downs there
either.
Anyone have any thoughts?
Thanks in advance...
-BBHi Brian,
My first though is that its not SQL Server thats causing this but perhaps
the machine iteself.
If you go to Administration Tools -> Performance and set up the following
counters.
Pages/sec
Avg. Disk Queue Length
% Processor time
Network -> Bytes Total / Second.
My own personal opionon here is you may need more memory.
Peter
"Brian Burgess" wrote:
> Hi all,
> I have a strange performance issue on one of our developer stations. Thi
s
> station is Trad Chinese WinXP Pro with SQLServer 2000 Dev Ed installed on
> it.
> The problems are:
> 1) The tools (like QA for instance) cannot connect to other SQL Servers o
n
> the network.
> 2) EM will take at least 1/2 minute to do any task. Any task like expan
d
> the Databases tree to show all the databases... or ... expand one of the
> databases to show the items(tables, storedproc, roles, etc) for that
> database .. or .. expand the tables tree to show all the tables ... etc
> This is a major problem since item 1 prevents this developer from testing
> against another SQL Server. And, at the same time item 2 prevents the
> developer from testing against his own local test server.
> I have tried all the common things:
> 1) Reinstall SQL Server (and Client Tools) on this station
> 2) scan the disk (for lost clusters and such)
> 3) remove temp and other useless files
> 4) defrag the disk
> Even the EM itself seems to repaint its windows slowly .. you can actually
> see the drawing process.
> The computer can otherwise access the network .. and no slow downs there
> either.
> Anyone have any thoughts?
> Thanks in advance...
> -BB
>
>|||Hi Peter,
I'm inclined to agree that it is more likely a hardware issue. However the
amount of RAM installed is 512MB. Memory and disk scan report no problems
(although these scans are not infallible).
I set these parameters up on the PerfMon ... any thing I should watch for?
Any SQL Server settings I can/should 'tweak'?
Thx
-BB
"Peter Nolan" <PeterNolan@.discussions.microsoft.com> wrote in message
news:11490686-81F5-462A-85A1-9804A25301C1@.microsoft.com...[vbcol=seagreen]
> Hi Brian,
> My first though is that its not SQL Server thats causing this but perhaps
> the machine iteself.
> If you go to Administration Tools -> Performance and set up the following
> counters.
> Pages/sec
> Avg. Disk Queue Length
> % Processor time
> Network -> Bytes Total / Second.
> My own personal opionon here is you may need more memory.
> Peter
>
> "Brian Burgess" wrote:
>
This[vbcol=seagreen]
on[vbcol=seagreen]
on[vbcol=seagreen]
expand[vbcol=seagreen]
testing[vbcol=seagreen]
actually[vbcol=seagreen]
No comments:
Post a Comment