Transcript Todd Klindt The guy losing his voice Solanite Consulting Shane Young The guy with his voice SharePoint911 OFC310

Todd Klindt
The guy losing his voice
Solanite Consulting
Shane Young
The guy with his voice
SharePoint911
OFC310
Who Am I?
Shane Young
Owner of SharePoint911.com
Microsoft Office SharePoint Server MVP
Consultant, Trainer, Writer, & Speaker
[email protected] Twitter - @shanescows
Blog
http://msmvps.com/shane
SharePoint Consulting
http://www.sharepoint911.com
SharePoint Training
http://www.tedpattison.net
Who is this Todd Klindt guy?
WSS MVP since 2006
Speaker, writer, consultant, Aquarius
Personal Blog
www.toddklindt.com/blog
Company web site
www.solanite.com
E-mail
[email protected] Twitter @ToddKlindt
I consider it an honor and privilege that Shane is
so mean to me.
Session Agenda
Overview of how SharePoint uses SQL
Overview of SQL versions and which you would
use for what
Care and feeding Best Practices for your
SQL server
A couple of cool SQL 2008 features to consider
SQL? I’m a SharePoint admin!
WSS and MOSS
Farm configuration is stored in SQL.
All SharePoint content is stored in SQL.
No exceptions! *
Central Admin is a web application and is in its
own content database
Search gets its own databases
* Except one
Content Databases
Every web application gets a content database
A web app may have multiple
content databases
A site collection must exist completely in a
single content database
A content database may have multiple
site collections
SharePoint Containment
Farm
Servers
Web Front End, APP, SQL
Web Applications
Central Admin, SSP Admin, Content
Databases
Content, Config, SSP, Search
Site Collections
The Bag
Sites
Portal, Wikis, Blogs, Team, Doc, Workspaces, Search Center
Lists
Doc Lib, Pages, Events, Discussions, Surveys, etc…
Items
Files, calendar items, contacts, customers, images, custom
Which Version of SQL?
SQL 2005 or 2008
64 bit
If you want to keep
a no cost install, use
SQL Express instead
SQL 2000
32 bit
Basic Install
Standard or Enterprise?
Standard features
Supports up to 4 CPUs (including cores)
Supports OS Maximum RAM, 4 GB of RAM on
32 bit OS
Failover is manual and restricted to two nodes
Supports database mirroring
Native 64 bit support
Movin’ on up…Enterprise
Full SQL 2005 functionality
Supports more than 4 CPUs
Support for up to 32 GB of RAM on 32 bit OS, OS
limitation, not SQL’s
Active failover for mirrors
KPI and Analysis Server built in
Comparison chart of all the versions at
http://www.microsoft.com/sql/prodinfo/features/c
ompare-features.mspx
Keep your SQL Server Happy
Maintenance Plans
Can be created manually or with a wizard
Easily modified with a graphical interface
Can include a variety of operations,
including backups
Can use SMTP to email plan success
What should I do in these?
Check database integrity
Reindex or rebuild database Indexes
Update statistics
Backups
Defrag the file system
Things you Should Do
Check Database Integrity
Verifies integrity of databases
Uses T-SQL command DBCC checkdb
Very disk and CPU intensive
Indexes
Reindex databases
Defragments database indexes
Rebuild Index
Completely recreates the database index
Not needed as often
Shrinking databases fragments your indexes and
your data
Backups
Can be part of maintenance plan
Three types
Full
Partial
Differential
Transaction logs
More Backup Recommendations
Can use built in software or third party
Allows for database compression and encryption
Results in smaller backups
Could also result in faster backups, if drive speed is
the bottleneck
SQL 2008 Enterprise support compression and
encryption out of the box
File system fragmentation
SQL will be faster if the database files are
contiguous in the file system
Using the built in defrag tool will have
performance ramifications
Consider using something like Diskeeper and its
intelligent defrag
Consider stopping SQL if possible
Drink me
Database size is reduced by dropping
unused space
Do not shrink databases unless something
drastic has happened
Massive site or content deletions
Removing site collections from v2 databases
Abandoning databases
Has a heavy impact on the server
Eat me
Databases grow, it is what they do
Grow operations are slow in SQL and will likely
result in a fragmented database file
Create database with enough space for one
year’s worth of growth
Database Best Practices
Create multiple TempDB files
Put database and corresponding transaction
logs on different spindles
Arrange databases according to speed
Use autogrow sparingly
Keep your databases under 100 GB
Use multiple content databases
More Points to Ponder
Do not alter databases - Microsoft HATES that
If using SQL 2005, install SP2
Can use SharePoint farm backups to
back up SQL
Don’t forget your system databases
SharePoint 2007 SP1 supports SQL 2008
Noodling around in SQL 2008
Todd Klindt
Senior Consultant
Solanite Consulting
Resources
www.microsoft.com/teched
www.microsoft.com/learning
Sessions On-Demand & Community
Microsoft Certification & Training Resources
http://microsoft.com/technet
http://microsoft.com/msdn
Resources for IT Professionals
Resources for Developers
www.microsoft.com/learning
Microsoft Certification and Training Resources
Track Resources
Spin the Wheel: Attend SharePoint breakout sessions Mon-Thurs and collect
the picture of the day. Come by the booth for a chance to spin the SharePoint
wheel. Collect all 4 pictures and enter to win a Microsoft Arc Mouse, drawing
11:30am on Friday, game cards at the booth.
Product Info http://www.microsoft.com/SharePoint
SharePoint Conference 2009 www.mssharepointconference.com
Dev Resources
SharePoint MSDN Web Site:
http://msdn.microsoft.com/sharepoint
SharePoint Developer Resources: http://mssharepointdeveloper.com/
ITPro Resources
SharePoint Tech Center: http://technet.microsoft.com/en-us/office/sharepointserver/
SharePoint Best Practices: http://technet.microsoft.com/enus/office/sharepointserver/bb736746.aspx
Collect the SharePoint Session Picture of the Day
Attend any SharePoint Breakout Session day 1 – 4 and
check the last slide for a daily picture.
Come to the TLC yellow area, SharePoint booths OFC 4
& 5 to spin the wheel for a chance to win a prize. The
wheel only spins when the SharePoint spotlight is
flashing. One spin per person.
Thursday’s Picture is:
Collect all four daily SharePoint pictures and enter to
win a Microsoft ARC Mouse. Game cards can be
picked up at the booth.
Drawing for Mice on Friday at the wheel at 11:30AM.
SharePoint Pie
Attend an Interactive Theater Session and enter to
win a Microsoft ARC Mouse
Complete an
evaluation on
CommNet and
enter to win!
© 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should
not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS,
IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.