Logo 
Search:

SQL FAQ

Submit Interview FAQ
Home » Interview FAQ » SQLRSS Feeds

What are some common hindrances of general performance?

  Shared By: Shruti Sharma    Date: Dec 21    Category: SQL    Views: 870

Answer:

Common performance pitfalls include

- Insufficient shared memory
- Limited number of available disk drives
- Improper usage of available disk drives
- Running large batch loads that are unscheduled
- Failing to commit or rollback transactions
- Improper sizing of tables and indexes

Share: 
 
 
 
 

Didn't find what you were looking for? Find more on What are some common hindrances of general performance? Or get search suggestion and latest updates.


Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].


Tagged: