Plan Installation Flashcards
What are all of the types of hardware that go into planning your installation?
Power - Multiple and UPS
Redundant Hardware - Hard Drives, Memory, etc
Clustering - Multiple servers running same DB
Multiple Copies of Database - Backups, Dev
Disk IO - HD Speed
Memory - More memory the better (Need x64)
CPU - Higher good, not AS important
Network IO - The higher the better
What should you install first before installing SQL server?
Required .NET Frameworks
What are the different editions of SQL Server?
Enterprise Developer [Business Intelligence] Standard Web Express
What are the years that SQL Server has been released?
2000 2005 2008 2008R2 2012 2014 2016 2017
What does Enterprise include?
All of the bells and whistles, everything that SQL has to offer. Huge price tag.
What does Developer include?
All of functionality of Enterprise but cannot be used for test and development.
What does Standard Include?
Basic data management and business intelligence. Not all features of Enterprise - thousands not tens of thousands
What does Web include?
Very low cost and small functionality for web hosters
What does Express include?
Entry level free version. Small data size. Can be used in real production instances.
What is the difference between scaling up and scaling out?
Scaling up - Increase system resources, processors, RAM, processor
Scaling out - Multiple SQL Servers
What are the ramifications for Scaling up?
Additional capital cost
Additional Licenses?
Limited testing needed
What are the ramifications for Scaling Out?
Engineering resources and time needed
Different SSMS/SSAS/SSRS servers
What files does Microsoft recommend go on your fastest disk?
Transaction logs and tempdb.
What size should you ideally allocate to your database?
As big as you expect it to grow. That way the system can allocate correctly and not fragment as much.
For autogrowth, what is Microsoft’s suggestion - Fixed Megabytes or Percent Growth?
Fixed Megabytes
