Expand a server group

[Trudye]

Hi everyong,

I would like to add a database to SQL Server. I dare not do it using anything but Enterprise Wizard.

When I looked up the process in BOL, the very first step is:
1. Expand a server group, and then expand the server in which to create a database.

Just how does one go about doing that?

As long as I have your attention I have another question. Since I installed SQL Server on my system my CPU usage stays at 100% even if I am not running anything and I shut down SQL Server. At least I think I'm shutting it down, I right click the icon on the toolbar and click exit.

The odd thing is my RAM usage is nil/nada. I have 5.5 gb of free space on my HDD. OBTW I am running SQL Server from my PC.

The reason I am complaining is my system has slowed to a crawl. Just opening Explorer is an all day event. Is there something I can do? Other than purchase a server and move SQL Server to it?

Thanks for any input or feedback you can provide.
Trudye

 

[nigelrivett]

Umm - should you be doing this on your own? I assume you have installed sql server at home.

First register your server.
Right click on sql server group and new sql server registration.
You will probably be on the server so type in the machine name or (local). I always prefer to start off as sa but if you installed as windows security only you will have to use a trusted connection.

How much memory do you have. Should be happy with 512M - don't have anything with less than that so don't know. Does the server start OK?


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Trudye]

Thanks Nigelrivett,

I knew I didn't have Enterprise Manager Wizard when I initially wrote this thread. I "assumed" I could just re-install and add that component. WRONG!

The only Wizard I have is Register your Server. When I re-installed I could not find Enterprise Manager Wizard under PERSONAL. I took every option except API Backup and still no Wizard. What ever will I do?

Does this mean I will have to create the database and load all of the tables using T-SQL?

I just registered my Server I used (LOCAL) because I did not know if I should enter the \\myname - sdxxxxxxx or myname- sdxxxxxx. I'm not user what registering will do for me but I'll try almost anything once.

Trudye

The server starts fine. I notice a slight increase in processing when I stop the SQl Server Service Manager. I have exactly 512mb RAM. However I am running from a laptop, allbeit a DELL (1.13 ghz processor).

 

[nigelrivett]

Which edition did you install?

You should have enterprise manager under "Microsoft SQL Server" in your programs.
If not do you have query analyser?

IMPORTANT
You need to install sp3.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Trudye]

In PROGRAMS under MS SQL Server I have: BOL, Client Network Utility, Config SQL XML Support in IIS, Enterprise Mngr, Import & Export Data, Profiler, Query Analyzer, Server Network Utility, Service Mngr.

I installed SQL Server a month ago and I installed SP3a. I remember having a slight problem with the install but no major problems.

I'm sorry if it is taking me a while to reply for some reason I am not getting email notification ( although it is checked).

Thanks much
Trudye

 

[Trudye]

Hooraaay! I used Import Data all tables are present and accounted for. I still have to assign primary keys but I just tested using Query Analyzer and everything looks OK.

Now all I have to do is figure out how to link the forms etc. to the tables.

Any suggestions?

Thanks for all our help
Trudye

 

[SQLBill]

In PROGRAMS under MS SQL Server I have: BOL, Client Network Utility, Config SQL XML Support in IIS, Enterprise Mngr, Import & Export Data, Profiler, Query Analyzer, Server Network Utility, Service Mngr.

You do have Enterprise Manager (there isn't any Enterprise Manager Wizard- EM has Wizards, but it isn't one). You also have the BOL (Books OnLine) which is SQL Server's Help.

Also, if you have further questions it would help if you include in your posts what SQL Server version you are using.

Good Luck.

-SQLBill

 

[Trudye]

Hi SQLBill, thanks for weighing in. I am unable to find EM Wizard that would allow me to created a new database.

DUH! I just found out if I click on Databases (icon) in EM and select 'Run a Wizard" from the toolbar I can see all of the wizards available to me.

I went to BOL first that what started this whole thread. BOL said I should:
1. Expand a server group, and then expand the server in which to create a database
But BOL did not explain how to do the expansion, so I posted a this thread.

I'm sorry I should have stated that up front, I have MS SQL 2000 (standard & personal). My OS is Win 2k.

 

[SQLBill]

When BOL (or anyone else) says to 'expand' something in Enterprise Manager, that usually means to click on the 'plus sign' next to whatever you need to expand.

So, in EM you should have seen 'Microsoft SQL Servers' with a plus to the left. Clicking on that would give you 'SQL Server Group'. If there is a plus to the left of that, you would click on it and it would give you your Instance. This will have the system databases (including Northwind and Pubs). If you didn't have an Instance, you could right click on the Server Group and select New SQL Server Registration. That would let you register (connect) your SQL Server Instance. (Every installation is an Instance of SQL Server).

In BOL you get what you ask for. Sometimes it's hard to know what to ask. In this case, you probably just looked up how to create a database. So BOL assumes you know how to register your Instance and expand to that.

-SQLBill

 

[wcburton]

I see that one of your original questions about performance was never answered. You said you right clicked on the icon in the system tray and chose exit. That is only the service manager - it is not SQL Server itself.

There are multiple processes or services that run when SQL is running. The main one is the server process, another is the SQL Server agent. The service manager allows you to stop/pause/start these processes or easily view their status.

To see what is keeping your CPU usage at 100%, you will need to learn how to use the process tab in the task manager (Windows - not SQL).

 

[Trudye]

Thank you so much SQLBill that made perfect sense. The good news is my Sever is Registered and all of my instances show up. The bad news is I can't get my New Database to talk to SQL Server. After creating it I made a change to the database but it was not reflected in EM. I tried to create an *.ADP file as BOL suggested but that did not help.

Thanks to you too WCBurton, I see exactly what you meant the pgm that is hogging the system is sqlsevr.exe at 99% CPU usage.
I stopped the Service Manager and again you are correct (oh smart one) sqlsevr.exe is still running at 99%. Is it ok if I stop it from Task Mngr or is there another way?

Thanks to both of you and everyone else you weighed in.

Have a GREAT weekend,
Trudye

 

[wcburton]

Do not stop it from Task Manager. You can restart the SQL service manager from the start menu. Then use the service manager to stop the service and allow it to shut down gracefully.

You can also go to the general control panel applet called services(which is actually an mmc console if you want to start looking that up). It is in the administrative tools section. You can stop/start any service from there.

 

[Trudye]

Sorry I didn't understand the first option. I tried stopping the Service Manager but it didn't stop sqlservr.exe.

I tried your second option: administrative tools; services; I issued a stop for MSSQLServer. Response: Error 1053, The service did not respond to the start or control request in a timely manner. I clicked OK, 2 1/2 hours later it still had not stopped, the status was "Stopping".

Thanx
Trudye

 

[wcburton]

Part one: using service manager to stop SQL server
you do not stop the service manager, you use it to stop SQL server. If the icon is in the system tray, a right click will show a menu. One of the options is stop SQL server. You can also double click the icon to bring up the full interface. A drop down box will allow you to choose between SQL Server, SQL Server Agent, and MSDTC. The stoplight buttons will then allow you to stop/pause/start whichever service is displayed in the drop down box.

Part two: service does not stop
it may be truly hung or it may be stuck trying to execute a command or query. you will need to learn some about using enterprise manager to inspect current activity and look for blocking or runaway processes. You will also be able to check the SQL logs from enterprise manager and look for errors there. Also check the windows event logs.

Will windows shut down cleanly or do you have to end task on sql server?
You can set service options in the administrative tools services applet so that SQL server does not start automatically - then you can start it manually when you are ready to play with it (this is all just a learning experience, right?)

Keep studying the Books OnLine and the FAQ's in this forum. Always be prepared to reinstall and take backups along the way.

When you find anything that looks strange or might be causing the problems, it would probably be best to start a new thread and let this one die since the original questions have been dealt with.

 

[Trudye]

Thank you so much wcburton for your feeback, I will heed your advice.

Trudye