Showing posts with label box. Show all posts
Showing posts with label box. Show all posts

Friday, March 30, 2012

Performance impact of Terminal Server on SQL Server

Hello,
We have a Windows 2000 Server box with SQL Server 7.0
installed. The database is maintained by a vendor, but
many customizations (other DBs) are built and maintained
on the same server by us (that's SQLServer={VendorDB1,
VendorDB2,...VendorDBN, OurDB1, OurDB2,...OurDBN}). We
desire to be able to manage the server (of the box, not
SQL Server) remotely via Terminal Server but our vendor
insists against it saying that it will adversely affect
the performance of the database. We do this with other
SQL Server boxes and have not noticed any significant
degradations in performance.
I've noticed the following: if I go to a Win2K Server box
running SQL Server and initiate a terminal server session
*away* from the box (to another machine), the SQL Server
performance drops significantly. However, if I am at a
remote machine and initiate a terminal server session
*to* a box running SQL Server, I experience no
performance problem(s).
Given the above, can anyone point me to any documentation
detailing performance issues related to Terminal Server
and SQL Server on the same machine? Can anyone clarify
the problem for me? That is, is it the case the SQL
Server performance will degrade if Terminal Server is
running *regardless* of whether you are connecting from
the box or to the box?
Thanks!
Quentinone connection into the sql server box for management and
administration should not be a big deal,
i would not run multiple terminal server sessions into a
heavily loaded sql server,
try running perfmon on the terminal server including the
context switches/sec counter.
open one session, run notepad and start typing a normal
rate.
each terminal server session will incur that amount of
load. at some point, the context switching rate will be
high enough to completely disrupt sql server,
but session for administrative purposes only is not bad,
>--Original Message--
>Hello,
>We have a Windows 2000 Server box with SQL Server 7.0
>installed. The database is maintained by a vendor, but
>many customizations (other DBs) are built and maintained
>on the same server by us (that's SQLServer={VendorDB1,
>VendorDB2,...VendorDBN, OurDB1, OurDB2,...OurDBN}). We
>desire to be able to manage the server (of the box, not
>SQL Server) remotely via Terminal Server but our vendor
>insists against it saying that it will adversely affect
>the performance of the database. We do this with other
>SQL Server boxes and have not noticed any significant
>degradations in performance.
>I've noticed the following: if I go to a Win2K Server box
>running SQL Server and initiate a terminal server session
>*away* from the box (to another machine), the SQL Server
>performance drops significantly. However, if I am at a
>remote machine and initiate a terminal server session
>*to* a box running SQL Server, I experience no
>performance problem(s).
>Given the above, can anyone point me to any documentation
>detailing performance issues related to Terminal Server
>and SQL Server on the same machine? Can anyone clarify
>the problem for me? That is, is it the case the SQL
>Server performance will degrade if Terminal Server is
>running *regardless* of whether you are connecting from
>the box or to the box?
>Thanks!
>Quentin
>.
>sql

Wednesday, March 28, 2012

Performance effect if SQL2000 and SQL2005 on same box

Hi everyone,
I am going to upgrade SQL2000 to SQL2005 because 3rd party application
requires SQL2005. My plan is upgrade my current database on SQL2000 to
SQL2005, but keeping SQL2000 for fall back plan.
Is there any impact on performance if I have SQL2005 and SQL2000 running on
the same machine?
Thanks alot for any help in advance.
Han.
The issues are not different from running two SQL2000 instances or two
SQL2005 instances.
Linchi
"Han" wrote:

> Hi everyone,
> I am going to upgrade SQL2000 to SQL2005 because 3rd party application
> requires SQL2005. My plan is upgrade my current database on SQL2000 to
> SQL2005, but keeping SQL2000 for fall back plan.
> Is there any impact on performance if I have SQL2005 and SQL2000 running on
> the same machine?
> Thanks alot for any help in advance.
> Han.
sql

Performance effect if SQL2000 and SQL2005 on same box

Hi everyone,
I am going to upgrade SQL2000 to SQL2005 because 3rd party application
requires SQL2005. My plan is upgrade my current database on SQL2000 to
SQL2005, but keeping SQL2000 for fall back plan.
Is there any impact on performance if I have SQL2005 and SQL2000 running on
the same machine?
Thanks alot for any help in advance.
Han.You will obviously have resource usage of you have both service started at the same time. But having
2000 installed but not started will not degrade performance of a 2005 install on that machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Han" <Han@.discussions.microsoft.com> wrote in message
news:FE01070A-7736-47CF-AECA-D9DB9CA5F75E@.microsoft.com...
> Hi everyone,
> I am going to upgrade SQL2000 to SQL2005 because 3rd party application
> requires SQL2005. My plan is upgrade my current database on SQL2000 to
> SQL2005, but keeping SQL2000 for fall back plan.
> Is there any impact on performance if I have SQL2005 and SQL2000 running on
> the same machine?
> Thanks alot for any help in advance.
> Han.|||The issues are not different from running two SQL2000 instances or two
SQL2005 instances.
Linchi
"Han" wrote:
> Hi everyone,
> I am going to upgrade SQL2000 to SQL2005 because 3rd party application
> requires SQL2005. My plan is upgrade my current database on SQL2000 to
> SQL2005, but keeping SQL2000 for fall back plan.
> Is there any impact on performance if I have SQL2005 and SQL2000 running on
> the same machine?
> Thanks alot for any help in advance.
> Han.

Monday, March 26, 2012

Performance DEV vs PROD - Same Equipment??

DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
query takes over an hour in PROD and about 20 minutes in DEV? As far as
I can tell their SQLServer settings are the same, I do have limited access.
Read something about a /3GB switch, we are using SQLServer 2000 and the
semi-dba indicated that we did not have that setup but didn't think it
needed to be. The semi-dba type is mainly Sybase and can't seem to find
any spare cycles to look at my problem. I am a developer and of course
past writing some SQL am far from expert on the DB stuff.
I have googled and found various information about databases and
indexing, which BTW, did find that our FillFactor was set incorrectly
as this system is reporting, updated once a month from a feed from the
main system. So reindexed everything with a fillFactor of 100%. It was
previously set at 75%? Didn't see any improvement in DEV so don't expect
anyhing great in PROD.
Anything is helpful at this point. I will be running to HalfPrice
books tomorrow to see what I can find that can help me.
JimD
On Sat, 14 Apr 2007 23:29:12 GMT, Jim Douglas
<james.douglas@.genesis-software.com> wrote:

>DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
>query takes over an hour in PROD and about 20 minutes in DEV? As far as
>I can tell their SQLServer settings are the same, I do have limited access.
Not to overlook the obvious, are you certain the *data* is the same in
Dev?
Try running profiler on both to see what resources are getting used.
J.
|||Hi Jim
"Jim Douglas" wrote:

> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
> query takes over an hour in PROD and about 20 minutes in DEV? As far as
> I can tell their SQLServer settings are the same, I do have limited access.
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and
> indexing, which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
> JimD
To add my 2c...
The usage of the two systems is likely to be different if these are not
processes that set the database into single user mode!! You may have blocking
on live which if you are the only person testing on your own database will
not happen on DEV. Rather than testing on DEV you may want to consider a
separate test environment which you can run simulated loads on. You should
also look at the query plans on the two different environments and also check
index fragmentations and the validity of the statistics.
John

Performance DEV vs PROD - Same Equipment??

DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
query takes over an hour in PROD and about 20 minutes in DEV? As far as
I can tell their SQLServer settings are the same, I do have limited access.
Read something about a /3GB switch, we are using SQLServer 2000 and the
semi-dba indicated that we did not have that setup but didn't think it
needed to be. The semi-dba type is mainly Sybase and can't seem to find
any spare cycles to look at my problem. I am a developer and of course
past writing some SQL am far from expert on the DB stuff.
I have googled and found various information about databases and
indexing, which BTW, did find that our FillFactor was set incorrectly
as this system is reporting, updated once a month from a feed from the
main system. So reindexed everything with a fillFactor of 100%. It was
previously set at 75%? Didn't see any improvement in DEV so don't expect
anyhing great in PROD.
Anything is helpful at this point. I will be running to HalfPrice
books tomorrow to see what I can find that can help me.
JimDOn Sat, 14 Apr 2007 23:29:12 GMT, Jim Douglas
<james.douglas@.genesis-software.com> wrote:

>DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
>query takes over an hour in PROD and about 20 minutes in DEV? As far as
>I can tell their SQLServer settings are the same, I do have limited access.
Not to overlook the obvious, are you certain the *data* is the same in
Dev?
Try running profiler on both to see what resources are getting used.
J.|||Hum., 20 minutes in DEV: with this kind of result, you shouldn't be
surprised to see the PROD to take much longer if its size is four times as
big.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Jim Douglas" <james.douglas@.genesis-software.com> wrote in message
news:ctdUh.1139$xP.1027@.trnddc04...
> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular query
> takes over an hour in PROD and about 20 minutes in DEV? As far as I can
> tell their SQLServer settings are the same, I do have limited access.
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and indexing,
> which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
> JimD
>|||"Jim Douglas" <james.douglas@.genesis-software.com> wrote in message
news:ctdUh.1139$xP.1027@.trnddc04...
> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular query
> takes over an hour in PROD and about 20 minutes in DEV? As far as I can
> tell their SQLServer settings are the same, I do have limited access.
What is the query?
And what is the schema for the tables involved?
A 20 minute query is a pretty long query in most cases (but not all.)

> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and indexing,
> which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
What made you decide to change this? Is this a datawarehouse or an OLTP.
In some cases 100% fill factor can make overall performance far worse.
(generally if yo're only selecting, it's great, you'll pack as much data
into the nodes of the b-tree as possible, but inserts will cost a lot more
overheard.)

> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
You running SQL 2000 or 2005?
> JimD
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Hi Jim
"Jim Douglas" wrote:

> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
> query takes over an hour in PROD and about 20 minutes in DEV? As far as
> I can tell their SQLServer settings are the same, I do have limited access
.
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and
> indexing, which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
> JimD
To add my 2c...
The usage of the two systems is likely to be different if these are not
processes that set the database into single user mode!! You may have blockin
g
on live which if you are the only person testing on your own database will
not happen on DEV. Rather than testing on DEV you may want to consider a
separate test environment which you can run simulated loads on. You should
also look at the query plans on the two different environments and also chec
k
index fragmentations and the validity of the statistics.
John

Performance DEV vs PROD - Same Equipment??

DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
query takes over an hour in PROD and about 20 minutes in DEV? As far as
I can tell their SQLServer settings are the same, I do have limited access.
Read something about a /3GB switch, we are using SQLServer 2000 and the
semi-dba indicated that we did not have that setup but didn't think it
needed to be. The semi-dba type is mainly Sybase and can't seem to find
any spare cycles to look at my problem. I am a developer and of course
past writing some SQL am far from expert on the DB stuff.
I have googled and found various information about databases and
indexing, which BTW, did find that our FillFactor was set incorrectly
as this system is reporting, updated once a month from a feed from the
main system. So reindexed everything with a fillFactor of 100%. It was
previously set at 75%? Didn't see any improvement in DEV so don't expect
anyhing great in PROD.
Anything is helpful at this point. I will be running to HalfPrice
books tomorrow to see what I can find that can help me.
JimDOn Sat, 14 Apr 2007 23:29:12 GMT, Jim Douglas
<james.douglas@.genesis-software.com> wrote:
>DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
>query takes over an hour in PROD and about 20 minutes in DEV? As far as
>I can tell their SQLServer settings are the same, I do have limited access.
Not to overlook the obvious, are you certain the *data* is the same in
Dev?
Try running profiler on both to see what resources are getting used.
J.|||Hum., 20 minutes in DEV: with this kind of result, you shouldn't be
surprised to see the PROD to take much longer if its size is four times as
big.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Jim Douglas" <james.douglas@.genesis-software.com> wrote in message
news:ctdUh.1139$xP.1027@.trnddc04...
> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular query
> takes over an hour in PROD and about 20 minutes in DEV? As far as I can
> tell their SQLServer settings are the same, I do have limited access.
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and indexing,
> which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
> JimD
>|||"Jim Douglas" <james.douglas@.genesis-software.com> wrote in message
news:ctdUh.1139$xP.1027@.trnddc04...
> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular query
> takes over an hour in PROD and about 20 minutes in DEV? As far as I can
> tell their SQLServer settings are the same, I do have limited access.
What is the query?
And what is the schema for the tables involved?
A 20 minute query is a pretty long query in most cases (but not all.)
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and indexing,
> which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
What made you decide to change this? Is this a datawarehouse or an OLTP.
In some cases 100% fill factor can make overall performance far worse.
(generally if yo're only selecting, it's great, you'll pack as much data
into the nodes of the b-tree as possible, but inserts will cost a lot more
overheard.)
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
You running SQL 2000 or 2005?
> JimD
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Hi Jim
"Jim Douglas" wrote:
> DEV and PROD same exact box, PROD has 4GB and DEV 1GB. A particular
> query takes over an hour in PROD and about 20 minutes in DEV? As far as
> I can tell their SQLServer settings are the same, I do have limited access.
> Read something about a /3GB switch, we are using SQLServer 2000 and the
> semi-dba indicated that we did not have that setup but didn't think it
> needed to be. The semi-dba type is mainly Sybase and can't seem to find
> any spare cycles to look at my problem. I am a developer and of course
> past writing some SQL am far from expert on the DB stuff.
> I have googled and found various information about databases and
> indexing, which BTW, did find that our FillFactor was set incorrectly
> as this system is reporting, updated once a month from a feed from the
> main system. So reindexed everything with a fillFactor of 100%. It was
> previously set at 75%? Didn't see any improvement in DEV so don't expect
> anyhing great in PROD.
> Anything is helpful at this point. I will be running to HalfPrice
> books tomorrow to see what I can find that can help me.
> JimD
To add my 2c...
The usage of the two systems is likely to be different if these are not
processes that set the database into single user mode!! You may have blocking
on live which if you are the only person testing on your own database will
not happen on DEV. Rather than testing on DEV you may want to consider a
separate test environment which you can run simulated loads on. You should
also look at the query plans on the two different environments and also check
index fragmentations and the validity of the statistics.
John

Wednesday, March 21, 2012

performance bottleneck?

how many users can a box with 8 processors and 32 GB RAM with sql
server 2000 on windows server 2003 handle effectively?
my web server with iis 6.0 on windows server 2003 has 4 processors and
8 GB RAM.
i have approx. 5000 active users - could give the connections in a few
days.
should i add more RAM/processing power on the web server to improve
performance?
or is it the bandwidth?
thanks
mdgandhi
"mdGandhi" <gandhimanisha@.gmail.com> wrote in message
news:1172497798.361738.245830@.z35g2000cwz.googlegr oups.com...
> how many users can a box with 8 processors and 32 GB RAM with sql
> server 2000 on windows server 2003 handle effectively?
> my web server with iis 6.0 on windows server 2003 has 4 processors and
> 8 GB RAM.
> i have approx. 5000 active users - could give the connections in a few
> days.
> should i add more RAM/processing power on the web server to improve
> performance?
> or is it the bandwidth?
> thanks
> mdgandhi
>
1 user
Or 50,0000.
Honestly, there's not enough information here to really give an answer.
For example, I had a 6 year old box (quad Xeon 700Mhz CPU) handling millions
of transactions an hour and probably could have handled another 30% in
traffic. So your box would be way overkill for that.
On the other hand I had a 4 year old box (dual Xeon CPU) handling a few
thousand transactions an hour that was overwhelmeed as it was. The
difference, the nature of the transactions.
That said, what you describe is a fairly beefy box. But it really depends
on what the users are doing.
Generally, focus on getting your queries to be effecient and to return no
more information than necessary. Then you can focus on bottlenecks after
taht.
I note for example you don't mention the disk subsystem at all. This can
have a HUGE impact on performance, especially if you're at all disk I/O
intensive.
Google around, there's a few books out there for calculating SQL Server
capacities. They may help you.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
|||The short answer is that there is no simple rule for determining how
many users a configuration can handle because it depends on the
specific work being performed. The best approach is to analyze the
current bottlenecks by analyzing how the machine runs now. Performance
Monitor is your friend.
Roy Harvey
Beacon Falls, CT
On 26 Feb 2007 05:49:58 -0800, "mdGandhi" <gandhimanisha@.gmail.com>
wrote:

>how many users can a box with 8 processors and 32 GB RAM with sql
>server 2000 on windows server 2003 handle effectively?
>my web server with iis 6.0 on windows server 2003 has 4 processors and
>8 GB RAM.
>i have approx. 5000 active users - could give the connections in a few
>days.
>should i add more RAM/processing power on the web server to improve
>performance?
>or is it the bandwidth?
>thanks
>mdgandhi

performance bottleneck?

how many users can a box with 8 processors and 32 GB RAM with sql
server 2000 on windows server 2003 handle effectively?
my web server with iis 6.0 on windows server 2003 has 4 processors and
8 GB RAM.
i have approx. 5000 active users - could give the connections in a few
days.
should i add more RAM/processing power on the web server to improve
performance?
or is it the bandwidth?
thanks
mdgandhi"mdGandhi" <gandhimanisha@.gmail.com> wrote in message
news:1172497798.361738.245830@.z35g2000cwz.googlegroups.com...
> how many users can a box with 8 processors and 32 GB RAM with sql
> server 2000 on windows server 2003 handle effectively?
> my web server with iis 6.0 on windows server 2003 has 4 processors and
> 8 GB RAM.
> i have approx. 5000 active users - could give the connections in a few
> days.
> should i add more RAM/processing power on the web server to improve
> performance?
> or is it the bandwidth?
> thanks
> mdgandhi
>
1 user
Or 50,0000.
Honestly, there's not enough information here to really give an answer.
For example, I had a 6 year old box (quad Xeon 700Mhz CPU) handling millions
of transactions an hour and probably could have handled another 30% in
traffic. So your box would be way overkill for that.
On the other hand I had a 4 year old box (dual Xeon CPU) handling a few
thousand transactions an hour that was overwhelmeed as it was. The
difference, the nature of the transactions.
That said, what you describe is a fairly beefy box. But it really depends
on what the users are doing.
Generally, focus on getting your queries to be effecient and to return no
more information than necessary. Then you can focus on bottlenecks after
taht.
I note for example you don't mention the disk subsystem at all. This can
have a HUGE impact on performance, especially if you're at all disk I/O
intensive.
Google around, there's a few books out there for calculating SQL Server
capacities. They may help you.
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||The short answer is that there is no simple rule for determining how
many users a configuration can handle because it depends on the
specific work being performed. The best approach is to analyze the
current bottlenecks by analyzing how the machine runs now. Performance
Monitor is your friend.
Roy Harvey
Beacon Falls, CT
On 26 Feb 2007 05:49:58 -0800, "mdGandhi" <gandhimanisha@.gmail.com>
wrote:
>how many users can a box with 8 processors and 32 GB RAM with sql
>server 2000 on windows server 2003 handle effectively?
>my web server with iis 6.0 on windows server 2003 has 4 processors and
>8 GB RAM.
>i have approx. 5000 active users - could give the connections in a few
>days.
>should i add more RAM/processing power on the web server to improve
>performance?
>or is it the bandwidth?
>thanks
>mdgandhi

performance bottleneck?

how many users can a box with 8 processors and 32 GB RAM with sql
server 2000 on windows server 2003 handle effectively?
my web server with iis 6.0 on windows server 2003 has 4 processors and
8 GB RAM.
i have approx. 5000 active users - could give the connections in a few
days.
should i add more RAM/processing power on the web server to improve
performance?
or is it the bandwidth?
thanks
mdgandhi"mdGandhi" <gandhimanisha@.gmail.com> wrote in message
news:1172497798.361738.245830@.z35g2000cwz.googlegroups.com...
> how many users can a box with 8 processors and 32 GB RAM with sql
> server 2000 on windows server 2003 handle effectively?
> my web server with iis 6.0 on windows server 2003 has 4 processors and
> 8 GB RAM.
> i have approx. 5000 active users - could give the connections in a few
> days.
> should i add more RAM/processing power on the web server to improve
> performance?
> or is it the bandwidth?
> thanks
> mdgandhi
>
1 user
Or 50,0000.
Honestly, there's not enough information here to really give an answer.
For example, I had a 6 year old box (quad Xeon 700Mhz CPU) handling millions
of transactions an hour and probably could have handled another 30% in
traffic. So your box would be way overkill for that.
On the other hand I had a 4 year old box (dual Xeon CPU) handling a few
thousand transactions an hour that was overwhelmeed as it was. The
difference, the nature of the transactions.
That said, what you describe is a fairly beefy box. But it really depends
on what the users are doing.
Generally, focus on getting your queries to be effecient and to return no
more information than necessary. Then you can focus on bottlenecks after
taht.
I note for example you don't mention the disk subsystem at all. This can
have a HUGE impact on performance, especially if you're at all disk I/O
intensive.
Google around, there's a few books out there for calculating SQL Server
capacities. They may help you.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||The short answer is that there is no simple rule for determining how
many users a configuration can handle because it depends on the
specific work being performed. The best approach is to analyze the
current bottlenecks by analyzing how the machine runs now. Performance
Monitor is your friend.
Roy Harvey
Beacon Falls, CT
On 26 Feb 2007 05:49:58 -0800, "mdGandhi" <gandhimanisha@.gmail.com>
wrote:

>how many users can a box with 8 processors and 32 GB RAM with sql
>server 2000 on windows server 2003 handle effectively?
>my web server with iis 6.0 on windows server 2003 has 4 processors and
>8 GB RAM.
>i have approx. 5000 active users - could give the connections in a few
>days.
>should i add more RAM/processing power on the web server to improve
>performance?
>or is it the bandwidth?
>thanks
>mdgandhi

Friday, March 9, 2012

performance

Are there any out of the BOX performance gains going from sql7 to sql2000 ?
ThanksYes, performance enhancements are numerous going from SQL7 to SQL2000. Bette
r
performance with differential backups, better parallelism with DBCC CHECKDB,
better peroformance with BLOB via such features as text in row, better
parallelism with CREATE INDEX, better large memory support, and so on. It's
night and day between SQL7 and SQL2000.
Funactionality improvement is huge as well.
Linchi
"Hoosbruin" wrote:

> Are there any out of the BOX performance gains going from sql7 to sql2000
?
>
> Thanks
>
>

Wednesday, March 7, 2012

performance

Are there any out of the BOX performance gains going from sql7 to sql2000 ?
ThanksYes, performance enhancements are numerous going from SQL7 to SQL2000. Better
performance with differential backups, better parallelism with DBCC CHECKDB,
better peroformance with BLOB via such features as text in row, better
parallelism with CREATE INDEX, better large memory support, and so on. It's
night and day between SQL7 and SQL2000.
Funactionality improvement is huge as well.
Linchi
"Hoosbruin" wrote:
> Are there any out of the BOX performance gains going from sql7 to sql2000 ?
>
> Thanks
>
>

Monday, February 20, 2012

Percentages are rounding and I don't want them to

Using SQLRS 2005
No matter how I format the percentage (using FormatPercent or "P" format
option, my text box in a table control rounds the percentage to a whole
percentage with zeroes in the decimal columns.
I don't want it to round off at all.
Any pointers?
--
John ShahanOn Jan 31, 12:49 pm, jp <j...@.discussions.microsoft.com> wrote:
> Using SQLRS 2005
> No matter how I format the percentage (using FormatPercent or "P" format
> option, my text box in a table control rounds the percentage to a whole
> percentage with zeroes in the decimal columns.
> I don't want it to round off at all.
> Any pointers?
> --
> John Shahan
I am not sure this will help but...
Leave the formatting alone and just use the expression builder
In database column (lets call is percentField), number is like this...
123.456789 then in expression builder '=Fields!percentField.Value +
"%" ' - field should look like 123.456789% on the report.
.123456789 then in expression builder '=(Fields!percentField.Value
*100) + "%" ' - field should look like 123.456789% on the report.
I hope that is what you were talking about and I hope that helps you.
Thanks and have a great day,
Kerrie|||Thank you very much for taking the time to respond.
I tried eliminating the formating as you suggested. And I now have
=Fields!JulPercentage.Value * 100 & "%" as the expression but it is still
taking a value like .026436346 (confirmed by looking at the result set in the
Data tab) and making it 3.00% in the table control on the report.
--
John Shahan
"Kerrie" wrote:
> On Jan 31, 12:49 pm, jp <j...@.discussions.microsoft.com> wrote:
> > Using SQLRS 2005
> > No matter how I format the percentage (using FormatPercent or "P" format
> > option, my text box in a table control rounds the percentage to a whole
> > percentage with zeroes in the decimal columns.
> >
> > I don't want it to round off at all.
> >
> > Any pointers?
> > --
> > John Shahan
> I am not sure this will help but...
> Leave the formatting alone and just use the expression builder
> In database column (lets call is percentField), number is like this...
> 123.456789 then in expression builder '=Fields!percentField.Value +
> "%" ' - field should look like 123.456789% on the report.
> ..123456789 then in expression builder '=(Fields!percentField.Value
> *100) + "%" ' - field should look like 123.456789% on the report.
> I hope that is what you were talking about and I hope that helps you.
> Thanks and have a great day,
> Kerrie
>|||On Feb 1, 4:49 am, jp <j...@.discussions.microsoft.com> wrote:
> Using SQLRS 2005
> No matter how I format the percentage (using FormatPercent or "P" format
> option, my text box in a table control rounds the percentage to a whole
> percentage with zeroes in the decimal columns.
> I don't want it to round off at all.
> Any pointers?
> --
> John Shahan
You can specify the number of decimal places you would like to see in
the percentage, using the
FormatPercent(number, DecimalPlaces) function. However, this will show
zeros if the percent is a whole number. If you want sometimes to show
decimal places, but to show no trailing zeros, then you probably need
to construct the number manually (division, then multiply by 100) and
add the % sign on the end as a string.
Rowen|||On Jan 31, 6:33 pm, "Rowen" <rowen...@.gmail.com> wrote:
> On Feb 1, 4:49 am, jp <j...@.discussions.microsoft.com> wrote:
> > Using SQLRS 2005
> > No matter how I format the percentage (using FormatPercent or "P" format
> > option, my text box in a table control rounds the percentage to a whole
> > percentage with zeroes in the decimal columns.
> > I don't want it to round off at all.
> > Any pointers?
> > --
> > John Shahan
> You can specify the number of decimal places you would like to see in
> the percentage, using the
> FormatPercent(number, DecimalPlaces) function. However, this will show
> zeros if the percent is a whole number. If you want sometimes to show
> decimal places, but to show no trailing zeros, then you probably need
> to construct the number manually (division, then multiply by 100) and
> add the % sign on the end as a string.
> Rowen
I would definitly try Rowan's suggestions, but what do you have the
format as on the table for that field? Something is set and it needs
to be turned off. I would leave it on 'General' or 'g' on the format
property.
Kerrie