RE: MS Server book

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Tue, 6 Jul 2004 15:39:14 +0100
Message-ID: <001201c46367$02bdf000$0a01a8c0@mark>

Dennis,=20

A service is basically a process that you can set to start automatically on system start up. You can also set service dependencies (e.g. ServiceA needs to be running before ServiceB can start). Services - as opposed to application processes - don=92t need a UI to run. Think of them as UNIX daemon processes.=20

You need to know how to start/stop them (Control Panel/Administrative Tools/Services menu), and you should also be aware of who the service runs as.. Most run as "LocalSystem", sometimes you have to switch these to a user with "Administrator" privileges.=20

You can *sometimes*, not very often, get registry corruptions. The registry is basically a "database" of application or service settings - like settings stored in config files in /etc for system wide (HKEY_LOCAL_MACHINE), or /home/username (HKEY_CURRENT_USER) for the current user. Also possibly like the rpm database. As Bob mentioned you get at the registry by running regedit from the Run command on the Start menu. It's probably a good idea to export a copy for a backup, or before trying to "hack" it ;)

In NT/2K environments, there is a "quick tweak" that can be set to make Windose optimise performance for either Applications (those with a GUI) or Background Services (as above). You can get at this in the Control Panel/System tool, under the Advanced tab, click the Performance Options button and set it for Background. You can also set you "Pagefile" (think swap space) from there too. The general rule is install the OS and any drivers that you need, install the database and *leave it alone*!! ;) The big problem with Windows stability is new patches and drivers and apps that just seem to get installed willy nilly on Windows systems - a lot of the time requiring a reboot.=20

Set the screen saver to "None" - and use the "Power" options to turn the monitor off after x minutes under the Display Properties (right click on the desktop - Properties menu).=20

HTH Mark

Mark Leith
Cool-Tools UK Limited

Tel: 01905 330 281
Fax: 08701 275 283
mark_at_cool-tools.co.uk
http://www.cool-tools.co.uk=20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS Sent: 06 July 2004 14:54
To: 'oracle-l_at_freelists.org'
Subject: RE: MS Server book

Bob - Thanks for your excellent reply. My problem is not knowing what I don't know. Your input is encouraging (as always), that maybe there isn't that much to it. And thanks for the excellent tips.

I'm not insisting on W2K for the Oracle DBA, although if the market supports a couple of Unix for the Oracle DBA, you'd think one for MS2K would not be unreasonable.
So far we've been able to keep Oracle on Unix, but like many of you, I'm being asked to start supporting SQL Server. On the wide variety of platforms it supports (joke).
I'm thinking maybe there is a MS2K book that has a few pertinent chapters.

Specific topics that concern me are:

What the heck is a service and what do I need to know?
I keep hearing about the registry and how it can mess you up.
Earlier NT systems needed to be reconfigured to support databases well. Is that still true? Is there a checklist to ensure a W2K is configured for SQL Server or Oracle? How do you ensure half the CPU isn't devoted to the screen server?

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com=20
I said it "looked" clear - Riddick

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of bobmetelsky_at_comcast.net
Sent: Monday, July 05, 2004 5:06 PM
To: oracle-l_at_freelists.org
Subject: Re: MS Server book

DENNIS WILLIAMS wrote:

>Thanks to everyone who has recommended Chris Kempster's ebook SQL=20
>Server 2000 for the Oracle DBA. This book is really a marvel. Since=20
>most of my professional experience is on Unix, I feel that I need to=20
>learn more about the MS Server. Can anyone recommend a resource that=20
>can get me up to speed with what I will need to know about the MS=20
>server? It seems that the boundary between the system administrator and

>the DBA isn't as clear as it is with Oracle and Unix.
> =20
>

Hi Dennis

Not to over simplify this but I don't believe there is such a book as=20 windows 2000 server for the oracle dba. I'm pretty sure most of the=20 administration books would gravitate toward using the server to=20 authenticate uses, manage users, what the various ms services do - how=20 to admin internet information server - how to recover from corrupt=20 registries - domain controllers and he like. From a DBA perspective (my=20 experience is exclusively on NT and 2000 server) there isn't too much to

it.=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.711 / Virus Database: 467 - Release Date: 25/06/2004
=20

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.711 / Virus Database: 467 - Release Date: 25/06/2004
=20

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 06 2004 - 09:33:17 CDT