Contents
What should be included in a server maintenance checklist?
By making sure that you’re keeping your server’s partition clean and trim of unnecessary data, old unused program versions, and archival logs, you can minimize the strain on your system and make sure no problems arise from not having enough free space!
How to determine the latest SQL Server Service Pack?
To determine the latest available service pack available for SQL Server, see the SQL Server Web site. You can use the following script to determine the service pack installed on the system. Principals are the individuals, groups, and processes granted access to SQL Server. “Securables” are the server, database, and objects the database contains.
How to check the performance of a server?
Performance monitoring tools like systat will provide baseline performance data for each of your server modules. Fill out the sub-checklist below after checking each component. Should you find that the server is pushing a component particularly hard, it’s best that you perform a spot of quick troubleshooting.
Can a SQL Server 2005 / 2008 instance register a SPN?
In an attempt to facilitate this, the SQL Server 2005/2008 instance will automatically try to register the SPN with the AD at startup if TCP/IP is enabled. The problem is, however, that only a domain administrator or a Local System account has the authority to register an SPN.
We monitor, review and maintain things 24/7, but if you are managing your own server, here are twelve items that should be part of your server maintenance checklist. 1. Verify your backups are working. Before making any changes to your production system, be sure that your backups are working.
How to choose the right user interface elements?
When designing your interface, try to be consistent and predictable in your choice of interface elements. Whether they are aware of it or not, users have become familiar with elements acting in a certain way, so choosing to adopt those elements when appropriate will help with task completion, efficiency, and satisfaction.
Typically search fields are single-line text boxes and are often accompanied by a search button. Breadcrumbs allow users to identify their current location within the system by providing a clickable trail of proceeding pages to navigate by.
What’s the best tool to keep track of servers?
Tools like Nagios, New Relic, Pingdom, sysstat and many other open source and SaaS products can help you keep tabs on your servers.