How do you fine the performance tunning?
Answer Posted / shivaraj
it is depends on
Data base design.
Hardware Sizing,
Application T- SQL codes- Indexes,Stored
Procedues,constraints
no of clients
no users
Type of data and Quantity base storage capacity on daily
basis
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a function and a stored procedure?
What are the requirements on sql server network connections?
What are the hotfixes and patches in sql server?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is difference between commit and rollback when used in transactions?
What is a not null constraint?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Can you please explain the difference between primary keys and foreign keys?
How to disable triggers using "disable trigger"?
Can we hide the definition of a stored procedure from a use?
Explain nested join?
What are unicode character string data types in ms sql server?
What is an execution plan? When would you use it?
How many non clustered indexes there can be on table ?
How you would rewrite the sql query to return the customerid sorted numerically?