December 11, 2009 at 9:22 am
Hi All,
I would like to get the logical/physical model of a database. I have been asked to analyze a database. But i don't have the model diagrams with me. so i would like to generate it. can anybody tell me the way to get the model diagram?
I am using sql2005. I have also some questions.
what kind of analysis that i have to do apart the below.
1)No of objects
2)No of record count
3)server location
4)HardDisk & RAM capacity of the machine where the sql server installed
5)No of Transaction (Per day)
6)No of transaction tables
7)No of users connect to the database.
what else?
karthik
December 11, 2009 at 10:46 am
In SSMS you can use Database Diagrams. Expand your database, right click the Folder called Database Diagrams and select "New Database Diagram."
Erwin also has a good modeling tool. Embarcadero also has a modeling program that has been recommended in these forums in the past. Another one is Power Architect.
Any of these tools could provide you the means to create your model.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 11, 2009 at 2:55 pm
You can also just use notepad.
+---------------------------+
| Employees |
+---------------------------+
| EmployeeID int |
| FirstName varchar(50) |
| LastName varchar(100) |
| ... (more fields ) ... |
+---------------------------+
|
|
|_______________________\ +---------------------------+
/ | Departments |
+---------------------------+
| DepartmentID int |
| DepartmentName varchar(50)|
| ... (more fields ) ... |
+---------------------------+
But considering how long it took for me to properly format that joke, I wouldn't advise it =)
December 11, 2009 at 3:36 pm
December 11, 2009 at 3:55 pm
karthikeyan-444867
what kind of analysis that i have to do apart the below.
I would add:
a. Schemas - do they appear appropriate
b. Security - in particular does any user have more rights than actually needed to do his/her job
c. Foreign key constraints
d. Triggers
e. Auditing
f. Review to determine possible slow responding T-SQL code., i.e., use of cursors.
g. Indexing
December 11, 2009 at 5:25 pm
Garadin (12/11/2009)
You can also just use notepad.
+---------------------------+
| Employees |
+---------------------------+
| EmployeeID int |
| FirstName varchar(50) |
| LastName varchar(100) |
| ... (more fields ) ... |
+---------------------------+
|
|
|_______________________\ +---------------------------+
/ | Departments |
+---------------------------+
| DepartmentID int |
| DepartmentName varchar(50)|
| ... (more fields ) ... |
+---------------------------+
But considering how long it took for me to properly format that joke, I wouldn't advise it =)
A bit too much time on your hands?
Good one though.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 12, 2009 at 4:10 pm
December 13, 2009 at 1:29 am
keep in mind SQLservers db diagram only shows the physical model !
Tools like Erwin, ... can support logical diagrams which will give your DA a good starting point on their work, and your DBA a great way of choosing their actual implementation strategies.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply