Posted in Community :
Media Mughals |
IT Sales and Business Development |
Database Administration |
7 more ...
Database Maintenance Optimization
Tags :
Database maintenance, Database optimization, sql server, sql server 2005, sql server 2008, sql server 2000, sql server database, microsoft sql server, sql server jobs, vb net sql server, database, sql database, sql developer, sql dba, sql server download, ms sql, mssql, sql, software, applications
Industry :
IT Products
Functional Area : Application Software |
|
|
Follow this Topic |
more actions >>
|
About "Database Maintenance Optimization" topic:
Many DBAs take routine database maintenance for granted. What they don�t understand is that the cumulative effect of poor database maintenance can significantly hurt performance. Here we shall discuss on the key things all DBAs need to know in order to maintain their databases at peak performance, including:
* Physical File Defragmentation
* Database and Log File Management
* tempdb Maintenance
* msdb Maintenance
* Index Maintenance
* Statistics Maintenance
* Data Corruption Detection
* Database and Log File Protection
* Database Maintenance Monitoring and many more.
1 trends
, 2 insight
, 3 debates
on topic: "Database Maintenance Optimization"
Prev1NextShowing 1 - 6 of 6
|
(rate this)
|
Optimization of any system obeys the Pareto Principle, which states that only a vital few factors are responsible for producing most of the problems. This is also known as the 80/20 Rule, meaning that most of the problems in a system result from just a few causes. Specifically, the biggest optimizations will be effected at the business process end of a system, then the application code, the database schema, and physical data storage, and the server configuration. In a business environment that does not yet have a unified approach to solving business problems by combining business process with technology, the system administrators would tend to apply optimization to the parts of the system t...
 |
Mohammed Anwer Khan
| Commented
| 1 year ago
|
|
Well said Mr manish. i liked it very much. But can you tell that your perspective will be the same if i change the database from SQLSERVER to ORACLE
|
|
Insight: "An Approach to Database Optimization" deleted from your view.
|
(rate this)
|
In few moments you will come to know about the magic tool that lets you to store data using a range of different data types, allowing the database engine to optimize its use of memory and storage, and also it performs various operations on the stored data more efficiently, effectively with fewer errors. Data type selection plays an important role in how efficiently your relational database management system functions, and so it is important to be fully aware of the options available to you, and to select the most appropriate data type for your storage needs. This article will explain the inportant applications of PostgreSQL , and provides you with a ready supply of choices the next time y...
Trends: "Database optimization with the power of PostgreSQL data types" deleted from your view.
|
(rate this)
|
|
MySQL
|
9
|
VS |
3
|
PostgreSQL
|
|
|
Chandra Singh Meena
| Argues in support of
"MySQL"
| 1 year ago
|
|
Follow the world
|
|
 |
Swapnil Hajare
| Argues in support of
"PostgreSQL"
| 2 years ago
|
|
We have used both Databases extensively. We used MySQL mainly for lightweight web applications and portals, while PostgreSQL for heavy GIS applications. Both performed well in these roles. However, when we tried using MySQL for a large usage web...
|
|
 |
Dennis Aries
| Argues in support of
"MySQL"
| 2 years ago
|
|
Highly debatable, but I have to go with MySQL here. Although, I have to confess, my experience with both is limited and probably a bit outdated too. Let me start out with some specifics that I know of. MySQL provides a smaller footprint, is...
|
|
Debate: "Which database is most suitable for business web applications? MySQL or PostgreSQL?" deleted from your view.
|
(rate this)
|
Top 5 DBA tasks that are a waste of time Some tasks performed by DBAs on a regular basis not only have little to no benefit to SQL Server, but can actually be detrimental to the health of their environments. #1. Shrinking the database Daily shrinking of the database is bad for a few reasons. From the technical side, the biggest impact you will see is a greatly increased index fragmentation after each database shrink. In addition, shrinking the database files increases both the physical file fragmentation on the disk subsystem and the I/O load on the server, which decreases performance for other functions while the shrink operation is running. Now it isn't the actual shrinking of the d...
|
|
Maruf khan
| Commented
| 1 year ago
|
|
Mr Atul i m to a DBA and having 4+ years of experience in this field i can challange u that the dba task which have specified are the junior dba level task u can do the automation of this task and the way dba works no other can work i can debate u...
|
|
 |
Thanigachalam T
| Commented
| 1 year ago
|
|
Good Article!!!! But the DBA is the "Mother" for Database, who Taking care of the Database without Downtime. These activities are very import for the DBA's and its day to day activity, which will make database health down. We can still handle this...
|
|
 |
Prarthana Devi
| Commented
| 2 years ago
|
|
Nice article Mr. Atul, one can look at the role of DBA in this way also, but whatever it may be, the importance of DBA cannot be denied in an organisation.
|
|
Insight: "DBA Waste of Time" deleted from your view.
|
(rate this)
|
|
SQL Server
|
1
|
VS |
0
|
Oracle
|
 |
Vikram Dheerendra Singh
| Argues in support of
"SQL Server"
| 1 year ago
|
|
SQL Server is very handy rather than Oracle. Interface very clear. Database Management easy. Backup/Recovery easy. Alter/Update/Modify easy.
|
|
Debate: "Relational Database Management System (RDBMS)" deleted from your view.
|
(rate this)
|
|
SQL Server
|
1
|
VS |
0
|
Oracle
|
|
|
Vikram Dheerendra Singh
| Argues in support of
"SQL Server"
| 1 year ago
|
|
Easy Interface. Start/Pause/Stop Database very fast. Installation process very easy. Backup/Restore as fast as possible. Easy connectivity with client machines.
|
|
Debate: "RDBMS - Relational Database Management System" deleted from your view.
Prev1NextShowing 1 - 6 of 6
Other knowledge matching "Database Maintenance Optimization" topic
|
Activity:
40 referals
,
1 comments,
0 views
|
|
Discover the Internet Market SEO or Search engine optimization is making use of a broad diversity of methods to advance a web site’s rankings on the result pages of search engines. While SEO certainly is the most required after the marketing services through internet, a lot of people who require it do not know what is involved. There are factually a lot of things that must be done to correctly optimize a web site. The optimization procedure of the web site of your company must commence as rapidly as possible. Claiming the Targeted Traffic The Search engine advertising , or else known as the "pay-per-click" advertising , is the most efficient way of advertising through online when you require arriving at a new market rapidly. Search Engine Marketing (SEM) is a continuing process which needs to monitor for keeping the "cost-per-click" down and the competition on the page ten. Come out from Inbox Chaos The Email marketing technique has now turned out to be the keystone of the CRM...
|
Similar Topics
Do you have a need to automate the deployment of your database schema?...
1 trends
, 1 insight
, 1 debates
, 1 question
SQL Server CLR integration is a powerful tool in the database developer�s...
2 insight
Out of the object patterns world, Domain Driven Design (DDD) is becoming a...
1 insight
, 1 question
While many DBAs may understand SQL Server 2008 Profiler basics, not too many...
3 insight
, 2 debates
, 1 question
1 trends
, 3 insight
, 1 idea contests
, 4 question
Sponsored Jobs
