Hardware requirements

I would like to know what are the suggested hardware
requirements for a Windows 2000 server box with SQL 2000
working in a very much busy environment.This question is so broad I doubt anyone could respond with a good answer.
You would need to perform some baseline testing with hardware to see how
your app performs then purchase appropriately.
-Lars
"Ricardo Bruno" <ricardo_bruno@.btsincusa.com> wrote in message
news:424401c3e435$7ef63490$a101280a@.phx.gbl...

quote:

---

> I would like to know what are the suggested hardware
> requirements for a Windows 2000 server box with SQL 2000
> working in a very much busy environment.

---

|||All together now...
"It Depends"
Seriously, you need to define just what 'busy' means. Batch
requests/second, transactions, client connections, database size and
throughput are all part of the mix. Most of the major server vendors have
tools to 'estimate' the size of a host server for SQL. They do a failrly
good job as long as your situation is not too unusual. Without a lot more
information I cannot give even a wild guess as to what you need.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Ricardo Bruno" <ricardo_bruno@.btsincusa.com> wrote in message
news:424401c3e435$7ef63490$a101280a@.phx.gbl...

quote:

---

> I would like to know what are the suggested hardware
> requirements for a Windows 2000 server box with SQL 2000
> working in a very much busy environment.

---

|||Ricardo,
It is a loaded question.
It is very hard to give any recommendation or suggestions based ont eh
information you have given.
Please check out the Operations Guide put together by Microsoft at the
following link.
Look at Chapter 6 which deals with Capacity planning. This is a good start.
http://www.microsoft.com/technet/tr...ide/default.asp
HTH
Satish Balusa
Corillian Corp.
"Ricardo Bruno" <ricardo_bruno@.btsincusa.com> wrote in message
news:424401c3e435$7ef63490$a101280a@.phx.gbl...

quote:

---

> I would like to know what are the suggested hardware
> requirements for a Windows 2000 server box with SQL 2000
> working in a very much busy environment.

---

Hardware requirements

I would like to know what are the suggested hardware
requirements for a Windows 2000 server box with SQL 2000
working in a very much busy environment.This question is so broad I doubt anyone could respond with a good answer.
You would need to perform some baseline testing with hardware to see how
your app performs then purchase appropriately.
-Lars
"Ricardo Bruno" <ricardo_bruno@.btsincusa.com> wrote in message
news:424401c3e435$7ef63490$a101280a@.phx.gbl...
> I would like to know what are the suggested hardware
> requirements for a Windows 2000 server box with SQL 2000
> working in a very much busy environment.|||All together now...
"It Depends"
Seriously, you need to define just what 'busy' means. Batch
requests/second, transactions, client connections, database size and
throughput are all part of the mix. Most of the major server vendors have
tools to 'estimate' the size of a host server for SQL. They do a failrly
good job as long as your situation is not too unusual. Without a lot more
information I cannot give even a wild guess as to what you need.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Ricardo Bruno" <ricardo_bruno@.btsincusa.com> wrote in message
news:424401c3e435$7ef63490$a101280a@.phx.gbl...
> I would like to know what are the suggested hardware
> requirements for a Windows 2000 server box with SQL 2000
> working in a very much busy environment.|||Ricardo,
It is a loaded question.
It is very hard to give any recommendation or suggestions based ont eh
information you have given.
Please check out the Operations Guide put together by Microsoft at the
following link.
Look at Chapter 6 which deals with Capacity planning. This is a good start.
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp
HTH
Satish Balusa
Corillian Corp.
"Ricardo Bruno" <ricardo_bruno@.btsincusa.com> wrote in message
news:424401c3e435$7ef63490$a101280a@.phx.gbl...
> I would like to know what are the suggested hardware
> requirements for a Windows 2000 server box with SQL 2000
> working in a very much busy environment.

HardDisk very busy while access SQL db

Dear all:
I'm using IIS6 + ASP + SQL2000sp3a. And between these month, when I connect
to my website, the harddisk will very busy, so my website become very slow.
But after HD read finished, the website will work fine.
I'm using virutal server, and another website work fine because it not
access sql server. I think its DB's problem.
Is there any method to check my db? Should I defrag my db or fix it'
Thank you very much for your read and reply!Fragmentation might be contributing to the performance problem, but there
are also many other problems as well. Performance tuning is a big topic & it
would be hard to suggest any one thing as being the most likely fix for your
problem given the limited info you've given here.
You need to follow a basic performance tuning approach - check high level
system metrics such as cpu, memory, disk queues etc. Then you make further
assumptions based on your observations & perhaps perform deeper system
analysis or go to the sql server performance tuning tools - such as SQL
Profiler. You might determine that large tables are being scanned or there
are concurrency / blocking issues.
The SQL Profiler also provides an out of the box performance tuning template
which is worth looking at. Long running query filtering from Profiler can
often reveal as single or small group of problem queries.
Ultimately, you may even have a hardware resource issue.
You might find some interesting material on
http://www.sql-server-performance.com
HTH
Regards,
Greg Linwood
SQL Server MVP
"Come2" <come2@.ms76.url.com.tw> wrote in message
news:#NWpd4ExDHA.2308@.TK2MSFTNGP11.phx.gbl...
> Dear all:
> I'm using IIS6 + ASP + SQL2000sp3a. And between these month, when I
connect
> to my website, the harddisk will very busy, so my website become very
slow.
> But after HD read finished, the website will work fine.
> I'm using virutal server, and another website work fine because it not
> access sql server. I think its DB's problem.
> Is there any method to check my db? Should I defrag my db or fix it'
> Thank you very much for your read and reply!
>

Handling database connection errors

If my database goes down, i get a popup error with the red x saying can't
connect to database, can't find the cubes, or the cubes are busy, etc...
Is there a way to change the error message to say:
"Report Cubes are being refreshed right now, please try again" in the
popup.
Or point to another page?No this is not possible, unless you implement your own custom data extension
which wraps the original data provider and throws specific exceptions with
your custom error message (which will then show up as inner error message).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:OfpbodJ3EHA.2804@.TK2MSFTNGP15.phx.gbl...
> If my database goes down, i get a popup error with the red x saying can't
> connect to database, can't find the cubes, or the cubes are busy, etc...
> Is there a way to change the error message to say:
> "Report Cubes are being refreshed right now, please try again" in the
> popup.
> Or point to another page?
>|||Is this an IIS thing?
Easy to do?
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OxvRcpP3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> No this is not possible, unless you implement your own custom data
extension
> which wraps the original data provider and throws specific exceptions with
> your custom error message (which will then show up as inner error
message).
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Cindy Lee" <cindylee@.hotmail.com> wrote in message
> news:OfpbodJ3EHA.2804@.TK2MSFTNGP15.phx.gbl...
> > If my database goes down, i get a popup error with the red x saying
can't
> > connect to database, can't find the cubes, or the cubes are busy,
etc...
> >
> > Is there a way to change the error message to say:
> >
> > "Report Cubes are being refreshed right now, please try again" in the
> > popup.
> >
> > Or point to another page?
> >
> >
>