2 Questions: license Installation and Speed

[aaron]

Hello,

I have two questions, first some background info:

We are running SQL 2000 on a Windows 2003 server for out aircraft
parts database software.

There are 7 workstations (windows 2000 and XP) that run the parts
database.

4 of those workstations run really fast, the database calls are near
instant. but the other 3 identical workstations are incredibly slow.
Taking over a minute to load what takes the other workstations less
then 2seconds, etc...

Since each workstation is identical (all XP are the same, all 2K are
the same) my first thought was that we didn't have enough SQL CAL
licenses for the 7 workstations, thus the 4 licenses we had were
allowing some to run fast, but the other 3 were qued up until space
became free, or something like that.

We purchased an additional 3 CAL licenses, but I'm not sure how to
install them...


My first question:

How do you actually go about installing SQL CAL licenses?
I went on the MS website, and it says to simply open up the control
panel, go into the SQL license Manager, and turn the spinner up to
the # of licenses you have.
Which I did.
Is that all there is to it?
I can't imagine you would simply be on your honor to put that spinner
to the correct number of licenses.


Question # 2
If that IS the correct way to install your licenses...
It made no difference in the 3 workstations SQL speed.
Yes I restarted the SQL service after upping the license amount.

These workstation are the same speed on the network as the "fast"
workstations in every other application and when sending files,
etc...

Any help greatly appreciated!
Take care
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[Erland Sommarskog]

aaron (aa***@axsstudios-dot-com.no-spam.invalid) writes:

We are running SQL 2000 on a Windows 2003 server for out aircraft
parts database software.

There are 7 workstations (windows 2000 and XP) that run the parts
database.

4 of those workstations run really fast, the database calls are near
instant. but the other 3 identical workstations are incredibly slow.
Taking over a minute to load what takes the other workstations less
then 2seconds, etc...

Since each workstation is identical (all XP are the same, all 2K are
the same) my first thought was that we didn't have enough SQL CAL
licenses for the 7 workstations, thus the 4 licenses we had were
allowing some to run fast, but the other 3 were qued up until space
became free, or something like that.

I'm sorry to disappoint you, but whatever causes that problem, it's not
the missing licensing. But I am glad to hear that you are no longer
violating the license agreement.

With the miniscule of information, it's difficult to say what the
problem might be. But as a shot in the dark: check that the problematic
machines does not have ODBC tracing active.

If that is not the culprit, I would use Profiler to find out whether
the slow clients gets the same query plans as the fast ones. If they
do, it's likely to be a network issue, maybe a bad choice of network
library configured. If plans are different, there are some settings
that are different.

It would also help if you gave some information about the architecture
of the application: Web or Windows Client? Client Library? Stored
procedures or ad hoc queries?

And, oh, which edition of SQL Server do you have?

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Andy O'Neill]

"aaron" <aa***@axsstudios-dot-com.no-spam.invalid> wrote in message
news:42********@127.0.0.1...

Hello,

I have two questions, first some background info:

We are running SQL 2000 on a Windows 2003 server for out aircraft
parts database software.

There are 7 workstations (windows 2000 and XP) that run the parts
database.

4 of those workstations run really fast, the database calls are near
instant. but the other 3 identical workstations are incredibly slow.
Taking over a minute to load what takes the other workstations less
then 2seconds, etc...

In addition to Erland's post....

I wonder if the three slow workstations are on a different hub to the 4 fast
ones.
--
Regards,
Andy O'Neill