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 are the steps to process a single select statement?
What is the difference between for auto and for nested?
What are the reporting services components?
What are the different types of triggers in SQL SERVER?
What is identity?
Which command is used for user defined error messages?
How can we use ConnectorJ JDBC Driver with MS SQL?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
How to define the name and server for a new dsn?
What do you understand by a view?
What is the filtered index?
Can one drop a column from a table?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Do you know what are pages and extents? : SQL Server Architecture