How do you fine the performance tunning?
Answer Posted / visala
first we have to check indexes are there or not,
check whether the statistics are updated or not,
check fragmentation is there or not,
check availability of joins,
check availability of aggregatefnctions,
may be networking problem,
may be hardware problem
then we tunne according to these problems
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can you tell me some of the common replication dmv's and their use? : sql server replication
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Explain about extended stored procedure?
What is updatable resultset?
Which are the olap features?
How to use group functions in the select clause in ms sql server?
Find columns used in stored procedure?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
How to rebuild master databse?
How to find out what is the default collation in a database?
How to include date and time values in sql statements?
What is proper subset of candidate key?
role of sql sever 2005 in database rather than any other database
how to create “alternate row colour”?
Name 3 ways to get an accurate count of the number of records in a table?