Each instance of SQL Server has a set of properties that you can configure to optimize how the database engine behaves. We'll cover these properties in this video.
- [Narrator] In our previous video…for the instance properties, we focused on…the memory processors security and connection settings.…Now let's take a look at the remaining settings.…And the first one we'll focus on here…are the database settings.…Now again, these are specific for the data…that we're storing on this instance of SQL server.…Our first option is the Default index fill factor.…And in order to understand how this applies to the data…and how it impacts our SQL server, we need to understand…how SQL server stores the data.…
Data is stored on the file system…in what are known as pages.…And by specifying our index fill factor…we determine how SQL server will make each page…when it comes to a new index, using our existing data.…So, in other words, the fill factor will affect performance…because SQL has to take time…to split the pages when they fill up.…So a page is only so large.…And typically it's around a 64 kilobyte size.…When that page fills up, SQL has to now create a new page…and move any new data that didn't get a chance…
Author
Released
11/9/2016This course is also ideal for anybody preparing for the Administering a SQL Database Infrastructure (70-764) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.
- Installation and configuration considerations
- Data storage strategies
- Configuring database instances
- Performance considerations
- Security considerations
- Managing roles and users
- Managing data
- High-availability options
Skill Level Intermediate
Duration
Views
Related Courses
-
SQL Server 2014 Essential Training
with Martin Guidry3h 51m Intermediate -
Database Foundations: Administration
with Adam Wilbert1h 14m Beginner -
Learning Microsoft SQL Server 2016
with Adam Wilbert1h 21m Beginner
-
Introduction
-
Welcome1m 7s
-
-
1. Installation and Configuration
-
Database storage strategies2m 53s
-
Install SQL Server7m 32s
-
Setting up the database4m 5s
-
2. Database Instances
-
Configure linked servers5m 38s
-
3. Performance Considerations
-
Using the profiler5m 41s
-
Auditing the database7m 4s
-
Resource governor5m 16s
-
4. Security
-
Manage roles3m 52s
-
Manage server logins4m 53s
-
Manage database users3m 36s
-
Manage database roles2m 28s
-
Implement server permissions4m 22s
-
Logon triggers4m 17s
-
-
5. Managing Data
-
Backup demonstration5m 26s
-
Moving database files4m 41s
-
Ensure data integrity5m 43s
-
6. High Availability Options
-
Database replication9m 36s
-
Log shipping5m 54s
-
Database mirroring2m 16s
-
Always On2m 32s
-
-
Conclusion
-
Next steps53s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Configure instance properties continued