Brent Ozar SQL Server DBA Training Course-Chapter I: Establishing a database server inventory

Source: Internet
Author: User

In the company, go into the sales Vice President's office and ask how many salespeople he has. No, I mean you don't have to do that, they'll ask you why the sales tools are so slow. In fact, I mean, if you could just go into his office and ask him the question. I bet he'll answer right away, without a moment's hesitation. Or you go into the CEO's office and ask him how many employees he has, or what the CFO's annual budget is, and they're sure to answer quickly. So my point is that when you're in charge of something, you need to know exactly what you're responsible for. make a list of tablesLet's start making a tabular list. At the top of the table, we list the following: SQL Server version (2005, 2008, 2012) database version (Standard, Enterprise, Developer) environment (production environment, test, development, disaster Recovery) department (sales, manpower Resource, accounting, IT, mixed use) the last column of the application name (internal or external) Plan B is a bit tricky for the affected users in the enterprise (the alarm mailing list to be sent when the server is down). Because Plan B means: If the server burns down in a fire, what are our plans? Are we recovering the database from another server? or fail over with transaction log shipping? or update your resume to find a new job? When we take a long-term approach to practice, we get more specific Plan B. There is no wrong answer, and in the first week we need to know what is going on, not what will happen in the future. We can never do what we want. (For me, I prefer to stay at the Lakeside bar, but I'm waiting for my girlfriend to blow her hair in the hotel.) If you want to know why I wrote so much, then you can thank her for the hair) if you have a plan, increase the CPU cores, the number of CPUs, and the memory in the list. You need to know more of the number of CPUs will require more software licensing fees, although software licensing is not in our contact program. What we need to do with this spreadsheetNow, you may sleep well at night, because you know what happens on all these servers. But I have some bad news for you. Over the next six months, we will gradually add more columns that have helped us to better understand the environment in Egypt. and solve the problem by discovering the problem through the checklist. In addition, add a reminder column, in the inside quickly write on the server to make people aware of the situation. They may be blocking problems, failed tasks, or error codes that you don't understand. 6 months from now, you'll be proud when this column changes. How to scan a database server in a network  Put each server in a column in the spreadsheet, whether or not you are responsible for managing it. There are two good free tools that can help us build a good directory listing. Microsoft Assessment and Planning Toolkit (Microsoft's Planning and Evaluation tool)--it's designed to do a Microsoft licensing compatibility check, but it's a great tool to build a server inventory. It scans your network and looks for the target program. However, it can only be used for Sqlser server. Quest Discovery Wizard for SQL Server (Quest) ——? This is a graphical tool that can scan your network and try to discover installed SQL Server instances. In a small store, if you have a Domain Admin account, you will find more database servers than you expect. These software do not require us to pay, we have been looking for the same tool. If you know a better tool, you can give[email protected]Send the message. See you next week.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.