Showing posts with label showing. Show all posts
Showing posts with label showing. Show all posts

Wednesday, March 21, 2012

Performance comparaison

I'm looking for a chart from Microsoft or 3rd party, showing the difference
of performance of SQL 2005 compared to SQL 2000 using exactly the same
hardware.
Basically, we are trying to show the management that we can have performance
gains if we go from a Windows 2000/SQL 2000, to a Windows 2003/SQL 2005
setup.
Thanks for all the help !!!
--
Why not run some performance benchmarks with SQL2000 adn SQL2005 on the same
hardware using the same workload that approximates your app? The
results--whatever they may be--would be more relevant and convincing than
anything you may find elsewhere.
Linchi
"Thinkpad21" wrote:

> I'm looking for a chart from Microsoft or 3rd party, showing the difference
> of performance of SQL 2005 compared to SQL 2000 using exactly the same
> hardware.
> Basically, we are trying to show the management that we can have performance
> gains if we go from a Windows 2000/SQL 2000, to a Windows 2003/SQL 2005
> setup.
> Thanks for all the help !!!
> --
> --
>
>

Performance comparaison

I'm looking for a chart from Microsoft or 3rd party, showing the difference
of performance of SQL 2005 compared to SQL 2000 using exactly the same
hardware.
Basically, we are trying to show the management that we can have performance
gains if we go from a Windows 2000/SQL 2000, to a Windows 2003/SQL 2005
setup.
Thanks for all the help !!!
--
--On 13.12.2006 12:34, Thinkpad21 wrote:
> I'm looking for a chart from Microsoft or 3rd party, showing the difference
> of performance of SQL 2005 compared to SQL 2000 using exactly the same
> hardware.
> Basically, we are trying to show the management that we can have performance
> gains if we go from a Windows 2000/SQL 2000, to a Windows 2003/SQL 2005
> setup.
I guess you will have a hard time searching for this. A simple
comparison that tells you SQL 2005 is 7.34% faster on the same hardware
is unrealistic. Performance highly depends on the workload and the
data. There might be cases where SQL 2005 is slower - IIRC there was a
recent thread about this phenomenon.
If your SQL 2k performs well and you do not urgently need features from
SQL 2005 then just stick with 2k. My 0.02EUR.
Kind regards
robert|||http://www.microsoft.com/sql/prodinfo/compare/benchmarks.mspx
http://www.devx.com/dbzone/Article/21539/1954?pf=true

Performance comparaison

I'm looking for a chart from Microsoft or 3rd party, showing the difference
of performance of SQL 2005 compared to SQL 2000 using exactly the same
hardware.
Basically, we are trying to show the management that we can have performance
gains if we go from a Windows 2000/SQL 2000, to a Windows 2003/SQL 2005
setup.
Thanks for all the help !!!
--
--On 13.12.2006 12:34, Thinkpad21 wrote:
> I'm looking for a chart from Microsoft or 3rd party, showing the differenc
e
> of performance of SQL 2005 compared to SQL 2000 using exactly the same
> hardware.
> Basically, we are trying to show the management that we can have performan
ce
> gains if we go from a Windows 2000/SQL 2000, to a Windows 2003/SQL 2005
> setup.
I guess you will have a hard time searching for this. A simple
comparison that tells you SQL 2005 is 7.34% faster on the same hardware
is unrealistic. Performance highly depends on the workload and the
data. There might be cases where SQL 2005 is slower - IIRC there was a
recent thread about this phenomenon.
If your SQL 2k performs well and you do not urgently need features from
SQL 2005 then just stick with 2k. My 0.02EUR.
Kind regards
robert|||http://www.microsoft.com/sql/prodin...benchmarks.mspx
http://www.devx.com/dbzone/Article/21539/1954?pf=true|||Why not run some performance benchmarks with SQL2000 adn SQL2005 on the same
hardware using the same workload that approximates your app? The
results--whatever they may be--would be more relevant and convincing than
anything you may find elsewhere.
Linchi
"Thinkpad21" wrote:

> I'm looking for a chart from Microsoft or 3rd party, showing the differenc
e
> of performance of SQL 2005 compared to SQL 2000 using exactly the same
> hardware.
> Basically, we are trying to show the management that we can have performan
ce
> gains if we go from a Windows 2000/SQL 2000, to a Windows 2003/SQL 2005
> setup.
> Thanks for all the help !!!
> --
> --
>
>

Saturday, February 25, 2012

perfmon to remote server

I'm not running SQLServer on my own workstation.
I am running perfmon, just as a matter of course, showing CPU and disk
and net traffic. I'd also like to monitor some remote SQLServers.
When I first clicked on the Add Counters dialog and typed in the name
of a SQLServer (say, "MySQLServer1"), it didn't connect, nothing
happened. But after I opened a fresh connection to MySQLServer1 for
the query analyzer, when I went back to perfmon, now it does list
\\MySQLServer1. But, it shows no properties for it.
Do I need some more advanced admin privileges on the remote boxes (or
network generally) for this to work?
Thanks.
JoshLocal Admins to read performance counters. Probably more specialized
security could be given, but Local Admins have the rights.
Sincerely,
Anthony Thomas
"jxstern" wrote:
> I'm not running SQLServer on my own workstation.
> I am running perfmon, just as a matter of course, showing CPU and disk
> and net traffic. I'd also like to monitor some remote SQLServers.
> When I first clicked on the Add Counters dialog and typed in the name
> of a SQLServer (say, "MySQLServer1"), it didn't connect, nothing
> happened. But after I opened a fresh connection to MySQLServer1 for
> the query analyzer, when I went back to perfmon, now it does list
> \\MySQLServer1. But, it shows no properties for it.
> Do I need some more advanced admin privileges on the remote boxes (or
> network generally) for this to work?
> Thanks.
> Josh
>

perfmon to remote server

I'm not running SQLServer on my own workstation.
I am running perfmon, just as a matter of course, showing CPU and disk
and net traffic. I'd also like to monitor some remote SQLServers.
When I first clicked on the Add Counters dialog and typed in the name
of a SQLServer (say, "MySQLServer1"), it didn't connect, nothing
happened. But after I opened a fresh connection to MySQLServer1 for
the query analyzer, when I went back to perfmon, now it does list
\\MySQLServer1. But, it shows no properties for it.
Do I need some more advanced admin privileges on the remote boxes (or
network generally) for this to work?
Thanks.
JoshLocal Admins to read performance counters. Probably more specialized
security could be given, but Local Admins have the rights.
Sincerely,
Anthony Thomas
"jxstern" wrote:

> I'm not running SQLServer on my own workstation.
> I am running perfmon, just as a matter of course, showing CPU and disk
> and net traffic. I'd also like to monitor some remote SQLServers.
> When I first clicked on the Add Counters dialog and typed in the name
> of a SQLServer (say, "MySQLServer1"), it didn't connect, nothing
> happened. But after I opened a fresh connection to MySQLServer1 for
> the query analyzer, when I went back to perfmon, now it does list
> \\MySQLServer1. But, it shows no properties for it.
> Do I need some more advanced admin privileges on the remote boxes (or
> network generally) for this to work?
> Thanks.
> Josh
>

perfmon to remote server

I'm not running SQLServer on my own workstation.
I am running perfmon, just as a matter of course, showing CPU and disk
and net traffic. I'd also like to monitor some remote SQLServers.
When I first clicked on the Add Counters dialog and typed in the name
of a SQLServer (say, "MySQLServer1"), it didn't connect, nothing
happened. But after I opened a fresh connection to MySQLServer1 for
the query analyzer, when I went back to perfmon, now it does list
\\MySQLServer1. But, it shows no properties for it.
Do I need some more advanced admin privileges on the remote boxes (or
network generally) for this to work?
Thanks.
Josh
Local Admins to read performance counters. Probably more specialized
security could be given, but Local Admins have the rights.
Sincerely,
Anthony Thomas
"jxstern" wrote:

> I'm not running SQLServer on my own workstation.
> I am running perfmon, just as a matter of course, showing CPU and disk
> and net traffic. I'd also like to monitor some remote SQLServers.
> When I first clicked on the Add Counters dialog and typed in the name
> of a SQLServer (say, "MySQLServer1"), it didn't connect, nothing
> happened. But after I opened a fresh connection to MySQLServer1 for
> the query analyzer, when I went back to perfmon, now it does list
> \\MySQLServer1. But, it shows no properties for it.
> Do I need some more advanced admin privileges on the remote boxes (or
> network generally) for this to work?
> Thanks.
> Josh
>