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 is the library index called?

773


What is truncate table?

705


How to delete duplicate rows from table except one?

705


When would you use the stored procedures or functions?

744


When columns are added to existing tables, what do they initially contain?

799






Can you always create a cache of a report?

145


How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

791


Can we add our custom code in ssis?

717


what are the reporting service components in SSRS?

139


What is the difference between mysql and mysqli?

752


What is the difference between createstatement and preparedstatement?

688


Explain the difference between cross join and full outer join?

670


How to override dml statements with triggers?

746


What are the different types of stored procedures?

789


How to use copy and concatenate commands in SQL?

776