December 11, 2001 at 3:40 am
Hi,
I am an Oracle DBA. Now I have to administer a SQL Server7.0 Database. Where can I find a document or listing which can map Oracle and SQL-Server.
December 11, 2001 at 6:52 am
I realize that this is a migration related document but, if you can understand what it takes to migrate, you should be better off in understanding how they compare. Hope this helps.
http://www.microsoft.com/SQL/techinfo/deployment/70/oraclemigrate.asp
Enjoy!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 11, 2001 at 10:12 am
Also, please feel free to post questions here for specific "how does SQL work" questions. We also have lots of beginning articles that should help you get up to speed.
Steve Jones
December 11, 2001 at 11:39 pm
Thanks for the help.
December 11, 2001 at 11:42 pm
Ok, to start with are there any system views and tables from which I can obtain information about the database. Like space usage, object ownership, user information etc.
December 12, 2001 at 4:35 am
Space information gets calculated when you need it - run sp_spaceused. Sysusers will hold the valid users for a db - they have an ID that maps to a login in syslogins in the master db (but look at the sysxlogins view, its easier). Object information is in sysobjects in each db.
Andy
December 12, 2001 at 10:07 am
Also the information_schema.xx views are SQL standards. There are:
tables
columns
etc. check master/views for the list.
Steve Jones
December 12, 2001 at 8:51 pm
Thanks for the help.
Another small but important thing, while managing Oracle I have a certain
checklist of things that are done regularly to check the status of database
like Segment usage, pin ratio, hit ratio, invalid status objects, buffer
size estimation and so on. For managing SQL-Server what can be the things
that should be checked up on a frequent basis. What I understand fully is
the SQL-Server manages the memmory allocation by itself (unlike oracle). In
that case what can be the plan of action.
Thanks.
December 13, 2001 at 4:53 am
You'll use Perfmon to see all the different counters. For memory, I generally look at SQL Buffer Cache Hit Ratio - should be above 90%. You're right that there is not a lot to tune, at any given time the idea is to find the bottleneck of either cpu, disk, or memory - and add more!
Andy
December 14, 2001 at 4:05 pm
Most of those items aren't a concern in SS. Andy's advice is a good start.
Steve Jones
December 15, 2001 at 4:52 am
You may also want to download the system table map - Books On Line - from the following;
http://www.microsoft.com/SQL/techinfo/productdoc/2000/systables.asp
I find this really useful in understanding how much of what goes on really works.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply