Solved

Quick Question - Transaction Processing/Database Design

Posted on 1998-12-14
3
187 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 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
T-SQL 10 35
SQL, add where clause 5 24
SQL Server Configuration Manager WMI Error 11 19
Index and Stats Management-Specific tables 8 22
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

829 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