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


Please Help Members By Posting Answers For Below Questions

What are the steps to process a single select statement?

515


What is the difference between for auto and for nested?

516


What are the reporting services components?

92


What are the different types of triggers in SQL SERVER?

541


What is identity?

557






Which command is used for user defined error messages?

563


How can we use ConnectorJ JDBC Driver with MS SQL?

568


Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

547


How to define the name and server for a new dsn?

549


What do you understand by a view?

559


What is the filtered index?

563


Can one drop a column from a table?

552


Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1125


what is a default tcp/ip socket assigned for sql server? : Sql server database administration

535


Do you know what are pages and extents? : SQL Server Architecture

554