473,230 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,230 software developers and data experts.

Need your expertise in SQL Server and Windows Server 2003

Ei guys Im Ryan from Philippines, I need your advice and
recommendations about Windows 2003 Server and SQL Server 2000
installation. Well, heres the scenario.

First is for windows 2003 server:
We have a windows 2003 server that is a Logon Server and we have at
least 90 workstation here in our office to manage. The problem is when
we connect to this logon server. It takes 15 to 20 minutes to connect
the workstation to the server. My guess is the specs of the logon
server. This is the Specs: An IBM computer with a pentium IV 3.0GHz
processor, 512MB memory and a 40Gig Harddisk. Well, is that enough to
be a logon server? What is the minimum requirements?

Second, SQL Server:
My boss wants me to setup a SQL Server in a Dell computer with 2.8GHz,
a 512mb of memory and a 80Gig Harddisk. My question is also the same,
Is it enough requirement?

And another thing, my boss wants me to install a SQL Server right?
Well he said that I should install it in the two partition, thats
Partition C: and D: (of course this is a dual OS of both Server 2003),
so thats two SQL server in one harddisk. His Strategy is to backup
the database from C to D and if in case the server in C: went down
then the other SQL (which is in D: drive) will start its operation.
Is this the right thing to do for SQL server, I mean is this the
proper way of doing things in SQL Server Administration? Is there any
complications on this?

Please guys, I need your advice and expertise about this incident.
Thanks in Advance..........

Very truly yours,

Ryan

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Disc...ict236171.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=819656
Jul 23 '05 #1
2 2052
Hi Ryan.

I won't be any help with the networking issues and my only opinion on
the dual OS would be to set up a RAID-1, but I wanted to just give you
a referrence point on the SQL server requirements concern. I'm the
database tech in an office with 9 clients on the network. Our server
is the only server and it handles all the network needs (except FAX).
Obviously, with only 9 clients and myself (using the server as a
workstation :-/ ), we have very little email/web/miscellaneous activity
on the network. Our server is running SQL Server Enterprise Edition in
a Windows Server 2003 Small Business environment. It has 2 Xeon 3.0
processors and a 90 GB RAID-5 setup with 4 GB of RAM.

Obviously when I use a SQL query through Query Analyzer, I get results
in milli-seconds. When I query a 2000 customer dbase through our
software application, called Enspire, the results take 2 or 3 seconds.
However, if I use a basic SELECT-FROM command in the Query Analyzer, I
don't have my finger off of the F5 key before the results are
displayed. Also note that we have a full Gigabit LAN (including switch
and network cards) and at any given time there may be 3 or 4 people
querying the dbase at once (lol, huge numbers isn't it?). If I look at
the Task Manager in Windows, a quick glance shows that 3 major
processes for sqlservr are running and taking 1.5 GB of RAM. That's
just the processes that I can identify by the name 'sqlservr'.

I'm sure this response won't help you come to a conclusion alone, but
hopefully if others respond, you and your boss will be able to weigh
out your options. If you need more detailed input, feel free to email
me.

Gabe Lawrence
ga*****@gmail.com

Jul 23 '05 #2
heyitsme_ryan (Us************@dbForumz.com) writes:
First is for windows 2003 server:
We have a windows 2003 server that is a Logon Server and we have at
least 90 workstation here in our office to manage. The problem is when
we connect to this logon server. It takes 15 to 20 minutes to connect
the workstation to the server. My guess is the specs of the logon
server. This is the Specs: An IBM computer with a pentium IV 3.0GHz
processor, 512MB memory and a 40Gig Harddisk. Well, is that enough to
be a logon server? What is the minimum requirements?
General Windows servers is not my speciality, but this should really
be enough, even if the amount of memory might be a tad small. The
reason for logons taking as ridiculously long time as 15-20 minutes
should be sought elsewhere.
Second, SQL Server:
My boss wants me to setup a SQL Server in a Dell computer with 2.8GHz,
a 512mb of memory and a 80Gig Harddisk. My question is also the same,
Is it enough requirement?
This depende largely on the application you intended to run. But it will
have to be a small database for 512 MB to be really sufficient. SQL Server
likes to keep as much data in cache as possible for good performance.
If you only can afford one more 5182 MB board, it's better to put it
in the SQL Server and not the logon server.
And another thing, my boss wants me to install a SQL Server right?
Well he said that I should install it in the two partition, thats
Partition C: and D: (of course this is a dual OS of both Server 2003),
so that's two SQL server in one harddisk. His Strategy is to backup
the database from C to D and if in case the server in C: went down
then the other SQL (which is in D: drive) will start its operation.
Is this the right thing to do for SQL server, I mean is this the
proper way of doing things in SQL Server Administration? Is there any
complications on this?


This does not really make much sense to me. The two OSs cannot be active
at the same time, so if one SQL Server goes down, there is no other to
jump in.

If you had different harddisks, it could make a little more sense, since
if one disk died, you could get an SQL Server running on the second
disk after some downtime.

If you need real redudancy with a fallback server coming on the point,
then you need a cluster. But the price tag for that hardware is somewhat
hefiter for what you have now.

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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Brad Tilley | last post by:
Does Python run on Windows Server 2003? http://www.python.org/download/download_windows.html only lists the following: Python for Windows 95, 98, NT, 2000, ME, XP
6
by: Nathan Sokalski | last post by:
I want to set up SQL Server on Windows XP Pro so that I can use the database capabilities of ASP and IIS. I am probably using some incorrect settings, but I am not sure what they are. Here is what...
1
by: Keith | last post by:
All, I have been told this is an ASP.NET issue and not an IIS issue, so I am posting this here. I have a problem with ASP.NET returning an HTTP 500 error when trying to run ASPX pages on...
3
by: Sam | last post by:
I wonder whether I should install .net framework 1.1 with service pack 1 into MS Windows 2003 Server? My inquiries Application using ASP.Net 1.1 - Will it run on MS Windows 2003 Server without...
22
by: EP | last post by:
When running my asp.net hosting service (asp.net without IIS), on server 2003 with IIS not installed, I get the following when trying to process a request. "System.DllNotFoundException: Unable to...
15
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...
14
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can...
8
by: David Thielen | last post by:
Hi; In our setup program how do I determine if I need to run "aspnet_regiis –i" and if so, is there an API I can calll rather than finding that program on the user's disk and calling it? --...
1
by: =?Utf-8?B?QW5kZXJ3IE1pbGxlcg==?= | last post by:
Apologies for posting in this forum, I don't see a more appropriate group... I'm trying to understand the timeline for Window 2003 ending mainstream support. I have consulted the MS lifecycle...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.