Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Quick Question - Transaction Processing/Database Design

Posted on 1998-12-14
3
Medium Priority
?
198 Views
Last Modified: 2010-03-19
Since transaction performance is critical (for large companies), in terms of the average number of transactions per minute and the average & maximum transaction response time, how does MS SQL allow the DBA to address this and related issues when configuring the system.

Also, does MS SQL provide any assistance to ensure that a database is in any Normal form.  I'm aware that the system will not allow conflicting itegrity constraints but that in its self doesn't address Normal forms.
0
Comment
Question by:John500
  • 2
3 Comments
 

Author Comment

by:John500
ID: 1092274
Edited text of question
0
 
LVL 3

Accepted Solution

by:
cognition earned 200 total points
ID: 1092275
SQL allows you to monitor a great deal of differnet statistics, using performance monitor. These include transaction levels, log space, maximum transactions and a host of other information. There are also DBCC commands that prodcue the same information, which could be used to create a customised monitoring tool.

Use of the monitoring tools ,and good use of indexes, and design will help to reduce the transaction levels. It also depends on what ype of system SQL Server is being used for.

There is nothing in SQL that helps enforce normal forms. Only a good database design can do that. I find that ERWin helps a great deal when designing databases. If SQL Server enforced normal forms, then you would not be able to de-normalize if required.


0
 

Author Comment

by:John500
ID: 1092276
Thanks, regarding normal forms, I should have known that!

John
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question