Interested to Buy Any Domain ? << Click Here >> for more details...
How do you fine the performance tunning?
- 2 Answers
- 8633 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How do use Having,Group by,Group function in SQL?
When would you use a before or after trigger?
What is the maximum size of sql server database?
Write a SQL Query to find first Week Day of month?
What is data compression?
What is raid? : SQL Server Architecture
Is candidate a key?
How can I check if a view exists in a sql server database?
Can you name a few encryption mechanisms in sql server?
What is a deadlock and what is a live lock?
How to connect a database with sql express.?
What is dbcc? Give few examples.
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
