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
How do I create a partition table in sql server?
What are the different acid properties?
What are click through reports?
How to use union to merge outputs from two queries together in ms sql server?
Is BCNF better than 2NF & 3NF? Why?
How to create an index on a view?
What are the fixed server level roles? : sql server security
What is the security principal at the database level that represents your session?
What type of Index will get created after executing the above statement?
What are temporal tables in sql server 2016?
How can a database be repaired?
What happens if an integer is too big for int date type?
what stored procedure would you use to view lock information? : Sql server administration
How to override dml statements with triggers?
How can I create a new template for import ? : sql server management studio