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
How much space should you always have on your hard drives?
25% open apart from the database (to allow for incidental growth)
What is HD Raid 0?
Disk Striping - Information spread between all disks (speed improvement)
What is HD Raid 1?
Disk Mirroring - Two disks are the same, if one disk fails, then no loss in data (redundancy) - Read improves
What is HD Raid 10?
Disk Striping and Mirrored - Highest combined read and write performance - Highest number of disks
What is HD Raid 5?
Striping with parity - disks have parity and one extra disk has enough data that it can replace any of the disks - Writing takes longer
What type should you use with Database file?
Raid 0 - because you should have backups
OR
Raid 1 on separate server if you need always on
What type should you use with Transaction file?
Probably Raid 1
