Has anyone used some software to test performance of SQL
Server that can cause many transactions against a given
server/database? We have a new application installed on a
server that is on-loan. We are still in training for the
app, but need to determine if our hardware and SQL Server
2000 can handle heavy user access (1200).
Anyone have some suggestionsWe use Application Center Test (similar to Web Application Stress Tool) to
drive our App and pound the DB.
Has been giving us consistent results and excellent data points.
Not perfect, but for a free tool, it seems to be doing the job for us.
Greg Jackson
PDX, Oregon|||the SQL resource kit has a tool for that purpose. If you have MSDN then it
is free :-)
"Fay" <anonymous@.discussions.microsoft.com> wrote in message
news:1b9501c426f0$0c94a050$a001280a@.phx.gbl...
> Has anyone used some software to test performance of SQL
> Server that can cause many transactions against a given
> server/database? We have a new application installed on a
> server that is on-loan. We are still in training for the
> app, but need to determine if our hardware and SQL Server
> 2000 can handle heavy user access (1200).
> Anyone have some suggestions
Showing posts with label software. Show all posts
Showing posts with label software. Show all posts
Wednesday, March 28, 2012
Performance testing
Has anyone used some software to test performance of SQL
Server that can cause many transactions against a given
server/database? We have a new application installed on a
server that is on-loan. We are still in training for the
app, but need to determine if our hardware and SQL Server
2000 can handle heavy user access (1200).
Anyone have some suggestionsWe use Application Center Test (similar to Web Application Stress Tool) to
drive our App and pound the DB.
Has been giving us consistent results and excellent data points.
Not perfect, but for a free tool, it seems to be doing the job for us.
Greg Jackson
PDX, Oregon|||the SQL resource kit has a tool for that purpose. If you have MSDN then it
is free :-)
"Fay" <anonymous@.discussions.microsoft.com> wrote in message
news:1b9501c426f0$0c94a050$a001280a@.phx.gbl...
> Has anyone used some software to test performance of SQL
> Server that can cause many transactions against a given
> server/database? We have a new application installed on a
> server that is on-loan. We are still in training for the
> app, but need to determine if our hardware and SQL Server
> 2000 can handle heavy user access (1200).
> Anyone have some suggestionssql
Server that can cause many transactions against a given
server/database? We have a new application installed on a
server that is on-loan. We are still in training for the
app, but need to determine if our hardware and SQL Server
2000 can handle heavy user access (1200).
Anyone have some suggestionsWe use Application Center Test (similar to Web Application Stress Tool) to
drive our App and pound the DB.
Has been giving us consistent results and excellent data points.
Not perfect, but for a free tool, it seems to be doing the job for us.
Greg Jackson
PDX, Oregon|||the SQL resource kit has a tool for that purpose. If you have MSDN then it
is free :-)
"Fay" <anonymous@.discussions.microsoft.com> wrote in message
news:1b9501c426f0$0c94a050$a001280a@.phx.gbl...
> Has anyone used some software to test performance of SQL
> Server that can cause many transactions against a given
> server/database? We have a new application installed on a
> server that is on-loan. We are still in training for the
> app, but need to determine if our hardware and SQL Server
> 2000 can handle heavy user access (1200).
> Anyone have some suggestionssql
Performance testing
Has anyone used some software to test performance of SQL
Server that can cause many transactions against a given
server/database? We have a new application installed on a
server that is on-loan. We are still in training for the
app, but need to determine if our hardware and SQL Server
2000 can handle heavy user access (1200).
Anyone have some suggestions
We use Application Center Test (similar to Web Application Stress Tool) to
drive our App and pound the DB.
Has been giving us consistent results and excellent data points.
Not perfect, but for a free tool, it seems to be doing the job for us.
Greg Jackson
PDX, Oregon
|||the SQL resource kit has a tool for that purpose. If you have MSDN then it
is free :-)
"Fay" <anonymous@.discussions.microsoft.com> wrote in message
news:1b9501c426f0$0c94a050$a001280a@.phx.gbl...
> Has anyone used some software to test performance of SQL
> Server that can cause many transactions against a given
> server/database? We have a new application installed on a
> server that is on-loan. We are still in training for the
> app, but need to determine if our hardware and SQL Server
> 2000 can handle heavy user access (1200).
> Anyone have some suggestions
Server that can cause many transactions against a given
server/database? We have a new application installed on a
server that is on-loan. We are still in training for the
app, but need to determine if our hardware and SQL Server
2000 can handle heavy user access (1200).
Anyone have some suggestions
We use Application Center Test (similar to Web Application Stress Tool) to
drive our App and pound the DB.
Has been giving us consistent results and excellent data points.
Not perfect, but for a free tool, it seems to be doing the job for us.
Greg Jackson
PDX, Oregon
|||the SQL resource kit has a tool for that purpose. If you have MSDN then it
is free :-)
"Fay" <anonymous@.discussions.microsoft.com> wrote in message
news:1b9501c426f0$0c94a050$a001280a@.phx.gbl...
> Has anyone used some software to test performance of SQL
> Server that can cause many transactions against a given
> server/database? We have a new application installed on a
> server that is on-loan. We are still in training for the
> app, but need to determine if our hardware and SQL Server
> 2000 can handle heavy user access (1200).
> Anyone have some suggestions
Wednesday, March 21, 2012
Performance Problems Sql2000 SP3 on W2003 Server
I'm running microsoft Sql for a Software called Everest FRom Icode. Two week
s
ago was but now when I check the w2003 performance screen sometimes sql use
over 60% of the resources. During top hours the server show 100% used. The
database is not even 1gb in size and we just have 20 users using the softwar
e
trought terminal services and the speed is bad and the performance is worst
any idea.
Thank you.Hi
Check that you have database maintenance scheduled to run perodically on
this database, this would re-organise indexes and update statistics. Your
vendor should be able to indicate what processes they have in place to carry
out this work. If they are carried out by scheduled tasks check in Enterpris
e
Manager for scheduled tasks which do this job that have failed.
In general SQL Server it is best to have SQL Server on a dedicate machine,
and not have it competing with other applications for resources.
John
"enriqueto" wrote:
> I'm running microsoft Sql for a Software called Everest FRom Icode. Two we
eks
> ago was but now when I check the w2003 performance screen sometimes sql us
e
> over 60% of the resources. During top hours the server show 100% used. The
> database is not even 1gb in size and we just have 20 users using the softw
are
> trought terminal services and the speed is bad and the performance is wors
t
> any idea.
> Thank you.
>
s
ago was but now when I check the w2003 performance screen sometimes sql use
over 60% of the resources. During top hours the server show 100% used. The
database is not even 1gb in size and we just have 20 users using the softwar
e
trought terminal services and the speed is bad and the performance is worst
any idea.
Thank you.Hi
Check that you have database maintenance scheduled to run perodically on
this database, this would re-organise indexes and update statistics. Your
vendor should be able to indicate what processes they have in place to carry
out this work. If they are carried out by scheduled tasks check in Enterpris
e
Manager for scheduled tasks which do this job that have failed.
In general SQL Server it is best to have SQL Server on a dedicate machine,
and not have it competing with other applications for resources.
John
"enriqueto" wrote:
> I'm running microsoft Sql for a Software called Everest FRom Icode. Two we
eks
> ago was but now when I check the w2003 performance screen sometimes sql us
e
> over 60% of the resources. During top hours the server show 100% used. The
> database is not even 1gb in size and we just have 20 users using the softw
are
> trought terminal services and the speed is bad and the performance is wors
t
> any idea.
> Thank you.
>
Performance Problems Sql2000 SP3 on W2003 Server
I'm running microsoft Sql for a Software called Everest FRom Icode. Two weeks
ago was but now when I check the w2003 performance screen sometimes sql use
over 60% of the resources. During top hours the server show 100% used. The
database is not even 1gb in size and we just have 20 users using the software
trought terminal services and the speed is bad and the performance is worst
any idea.
Thank you.
Hi
Check that you have database maintenance scheduled to run perodically on
this database, this would re-organise indexes and update statistics. Your
vendor should be able to indicate what processes they have in place to carry
out this work. If they are carried out by scheduled tasks check in Enterprise
Manager for scheduled tasks which do this job that have failed.
In general SQL Server it is best to have SQL Server on a dedicate machine,
and not have it competing with other applications for resources.
John
"enriqueto" wrote:
> I'm running microsoft Sql for a Software called Everest FRom Icode. Two weeks
> ago was but now when I check the w2003 performance screen sometimes sql use
> over 60% of the resources. During top hours the server show 100% used. The
> database is not even 1gb in size and we just have 20 users using the software
> trought terminal services and the speed is bad and the performance is worst
> any idea.
> Thank you.
>
ago was but now when I check the w2003 performance screen sometimes sql use
over 60% of the resources. During top hours the server show 100% used. The
database is not even 1gb in size and we just have 20 users using the software
trought terminal services and the speed is bad and the performance is worst
any idea.
Thank you.
Hi
Check that you have database maintenance scheduled to run perodically on
this database, this would re-organise indexes and update statistics. Your
vendor should be able to indicate what processes they have in place to carry
out this work. If they are carried out by scheduled tasks check in Enterprise
Manager for scheduled tasks which do this job that have failed.
In general SQL Server it is best to have SQL Server on a dedicate machine,
and not have it competing with other applications for resources.
John
"enriqueto" wrote:
> I'm running microsoft Sql for a Software called Everest FRom Icode. Two weeks
> ago was but now when I check the w2003 performance screen sometimes sql use
> over 60% of the resources. During top hours the server show 100% used. The
> database is not even 1gb in size and we just have 20 users using the software
> trought terminal services and the speed is bad and the performance is worst
> any idea.
> Thank you.
>
Performance Problems Sql2000 SP3 on W2003 Server
I'm running microsoft Sql for a Software called Everest FRom Icode. Two weeks
ago was but now when I check the w2003 performance screen sometimes sql use
over 60% of the resources. During top hours the server show 100% used. The
database is not even 1gb in size and we just have 20 users using the software
trought terminal services and the speed is bad and the performance is worst
any idea.
Thank you.Hi
Check that you have database maintenance scheduled to run perodically on
this database, this would re-organise indexes and update statistics. Your
vendor should be able to indicate what processes they have in place to carry
out this work. If they are carried out by scheduled tasks check in Enterprise
Manager for scheduled tasks which do this job that have failed.
In general SQL Server it is best to have SQL Server on a dedicate machine,
and not have it competing with other applications for resources.
John
"enriqueto" wrote:
> I'm running microsoft Sql for a Software called Everest FRom Icode. Two weeks
> ago was but now when I check the w2003 performance screen sometimes sql use
> over 60% of the resources. During top hours the server show 100% used. The
> database is not even 1gb in size and we just have 20 users using the software
> trought terminal services and the speed is bad and the performance is worst
> any idea.
> Thank you.
>
ago was but now when I check the w2003 performance screen sometimes sql use
over 60% of the resources. During top hours the server show 100% used. The
database is not even 1gb in size and we just have 20 users using the software
trought terminal services and the speed is bad and the performance is worst
any idea.
Thank you.Hi
Check that you have database maintenance scheduled to run perodically on
this database, this would re-organise indexes and update statistics. Your
vendor should be able to indicate what processes they have in place to carry
out this work. If they are carried out by scheduled tasks check in Enterprise
Manager for scheduled tasks which do this job that have failed.
In general SQL Server it is best to have SQL Server on a dedicate machine,
and not have it competing with other applications for resources.
John
"enriqueto" wrote:
> I'm running microsoft Sql for a Software called Everest FRom Icode. Two weeks
> ago was but now when I check the w2003 performance screen sometimes sql use
> over 60% of the resources. During top hours the server show 100% used. The
> database is not even 1gb in size and we just have 20 users using the software
> trought terminal services and the speed is bad and the performance is worst
> any idea.
> Thank you.
>
Saturday, February 25, 2012
Performance Monitoring and Fine Tuning SQL Server 2000
Hi
does anyone know of any good performance monitoring software for Microsoft SQL Server 2000? How about any articles on Fine tuning your SQL server?
thanks
Bonmil,
there's loads of articles on performance tuning on the web. Here are a few
central ones:
http://www.sql-server-performance.co...ce_article.asp
http://support.microsoft.com/default...b;en-us;322883
http://www.sql-server-performance.co...r_counters.asp
http://www.myitforum.com/articles/18/view.asp?id=5088
There's usually no need to buy any additional software - Windows Performance
Monitor (perfmon) has a huge array of counters for your use. Quest Software
have a slightly easier-to-use tool that you might like to investigate, after
getting used to the main counters in perfmon.
HTH,
Paul Ibison
does anyone know of any good performance monitoring software for Microsoft SQL Server 2000? How about any articles on Fine tuning your SQL server?
thanks
Bonmil,
there's loads of articles on performance tuning on the web. Here are a few
central ones:
http://www.sql-server-performance.co...ce_article.asp
http://support.microsoft.com/default...b;en-us;322883
http://www.sql-server-performance.co...r_counters.asp
http://www.myitforum.com/articles/18/view.asp?id=5088
There's usually no need to buy any additional software - Windows Performance
Monitor (perfmon) has a huge array of counters for your use. Quest Software
have a slightly easier-to-use tool that you might like to investigate, after
getting used to the main counters in perfmon.
HTH,
Paul Ibison
Performance Monitoring and Fine Tuning SQL Server 2000
H
does anyone know of any good performance monitoring software for Microsoft SQL Server 2000? How about any articles on Fine tuning your SQL server
thanksBonmil,
there's loads of articles on performance tuning on the web. Here are a few
central ones:
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;322883
http://www.sql-server-performance.com/performance_monitor_counters.asp
http://www.myitforum.com/articles/18/view.asp?id=5088
There's usually no need to buy any additional software - Windows Performance
Monitor (perfmon) has a huge array of counters for your use. Quest Software
have a slightly easier-to-use tool that you might like to investigate, after
getting used to the main counters in perfmon.
HTH,
Paul Ibison
does anyone know of any good performance monitoring software for Microsoft SQL Server 2000? How about any articles on Fine tuning your SQL server
thanksBonmil,
there's loads of articles on performance tuning on the web. Here are a few
central ones:
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;322883
http://www.sql-server-performance.com/performance_monitor_counters.asp
http://www.myitforum.com/articles/18/view.asp?id=5088
There's usually no need to buy any additional software - Windows Performance
Monitor (perfmon) has a huge array of counters for your use. Quest Software
have a slightly easier-to-use tool that you might like to investigate, after
getting used to the main counters in perfmon.
HTH,
Paul Ibison
Performance Monitoring and Fine Tuning SQL Server 2000
Hi
does anyone know of any good performance monitoring software for Microsoft S
QL Server 2000? How about any articles on Fine tuning your SQL server?
thanksBonmil,
there's loads of articles on performance tuning on the web. Here are a few
central ones:
http://www.sql-server-performance.c...nce_article.asp
http://support.microsoft.com/defaul...kb;en-us;322883
http://www.sql-server-performance.c...or_counters.asp
http://www.myitforum.com/articles/18/view.asp?id=5088
There's usually no need to buy any additional software - Windows Performance
Monitor (perfmon) has a huge array of counters for your use. Quest Software
have a slightly easier-to-use tool that you might like to investigate, after
getting used to the main counters in perfmon.
HTH,
Paul Ibison
does anyone know of any good performance monitoring software for Microsoft S
QL Server 2000? How about any articles on Fine tuning your SQL server?
thanksBonmil,
there's loads of articles on performance tuning on the web. Here are a few
central ones:
http://www.sql-server-performance.c...nce_article.asp
http://support.microsoft.com/defaul...kb;en-us;322883
http://www.sql-server-performance.c...or_counters.asp
http://www.myitforum.com/articles/18/view.asp?id=5088
There's usually no need to buy any additional software - Windows Performance
Monitor (perfmon) has a huge array of counters for your use. Quest Software
have a slightly easier-to-use tool that you might like to investigate, after
getting used to the main counters in perfmon.
HTH,
Paul Ibison
Subscribe to:
Posts (Atom)