In this article we look into some of key mistakes that a DBA must look to avoid while working on SQL Server
Whether you agree or not but a database administrator or DBA has to face a lot of problems while working on an SQL server. A DBA not only has to find but also fix the problems cropping up in such servers, so it is very important to know some common mistakes that should be avoided at all cost for a smoother functioning of the database. In fact, just a small carelessness on part of the DBA can result into big losses for a company. So, here is a check list of the key mistakes that a SQL Server DBA must look to avoid.
- Do Restrict Security Access: The first important mistake to avoid by a DBA is that he or she should never ignore restricting the security access for the server. In fact, many times DBAs forget restricting the security of the server and don’t give proper consideration for permissions for access to different people, who may steal away the crucial data from the server database. DBA should be careful in granting permissions to users, other administrators and developers according to the usage.
- Do Keep Your Database Maintained Regularly: It is equally important to pay attention to your database maintenance on a regular basis. Yes, its true that SQL servers come with the auto tuning and auto updating features, yet it is important to perform various database maintenance tasks on a regular basis to get acquainted with latest features or updates available. You may even use an SQL agent to generate a maintenance plan.
- Do Monitor Your Server Utilization: A DBA can also not dare to avoid monitoring the server utilization time to time for better performance. You are in fact, suggested to check the system’s performance on a periodic basis to see the overall CPU utilization, I/O, memory, locking and storage issues of the server. The best advantage of doing so is that you can ensure a normal working of your server and can catch hold of any issues cropping up in between.
- Do Consider Disk Storage & IO: Another thing a DBA must not forget is to check the disk storage as well as the IO. It has been observed that many times a DBA pays attention in just expanding and managing the disk storage without thinking about the IO load. It should be noted that SQL servers with insufficient IO will yield poor performance even if they have good disk storage.
- Do Test Your Server Backup: Lastly and most importantly, you as a DBA can’t afford to ignore the server backup; else you are risking not just the Server data but your own job as well. Make sure to test your server backup on a regular basis for disaster recovery at any moment of time. If there is a proper database backup, you can use it at the worst time, to restore your server; however, make sure to use the option of backup on verification only for more data security.
SQL Server 2016 is rich in features but not robust enough to avoid SQL crashes
The SQL Server 2016 iteration is loaded with features which can warm the heart of every DBA. Yet it is not robust enough to avoid SQL crashes. So a sql recovery tool like DataNumen SQL Recovery is a necessity if you are looking to protect your data in every scenario. If and when your database crashes, this advanced tool can swing into action and recover all data stored in the database without breaking a sweat. Moreover it is capable of recovering indexes, OLE data and any other data elements stored in the database.
Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit https://www.datanumen.com/