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 new data source types were added in ssrs 2014?
What part does database design plays a role in performance of an sql server-based application?
Does order by actually change the order of the data in the tables or does it just change the output?
How to edit table in sql server 2017?
What are the three different part of rdl file explain them?
What information is maintained within the msdb database?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is instead of trigger sql server?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
How you can add messages to the nt event log from within a stored procedure?
What is repeatable read?
What is the difference between resultset and resultsetmetadata?
What is a non clustered primary key?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What authentication modes does sql server support?