Solved

Quick Question - Transaction Processing/Database Design

Posted on 1998-12-14
3
194 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

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

Accepted Solution

by:
cognition earned 50 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

Independent Software Vendors: 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

Suggested Solutions

Title # Comments Views Activity
EF5 How do I stop pre-compiled views? 8 57
SQL Server - Multiple Conditions on Left or RIGHT Joins 2 30
sql server query 9 28
MS SQL TO JSON 14 19
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

710 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