Feeds:
Posts
Comments

Posts Tagged ‘content database’

Dear all,

it is my pleasure to announce a new initiative of communicating SharePoint knowledge via videos using the “SharePointFive” approach: Show how technical configurations are done within only a few minutes (guideline: 5 mins per video, up to a max of 15 in special cases.

If you want to learn about SharePoint 2010 configurations, but only want to invest a few minutes at a time, if you are looking for the essentials that make up what you actually want to do, then SharePointFive is for you.

SharePointFive (SharePoint5)

SharePointFive is a youtube channel, that you can access under the below mentioned URL. It contains all videos (currently 1 only :-)) that have been and will be published, showing how to apply SharePoint (or related) configurations in just a few minutes. Usually, like in this case, there will be published a related blog post on angler.wordpress.com, in order to facilitate it for you to copy scripts and apply them.

SP5Logo

http://www.youtube.com/sharepointfive

The Video

The video will give you an idea of the steps to be executed, a few caveats. But most of all, it is only a few minutes long and won’t take a long time to watch. This first episode of SharePointFive is  a bit longer (about 12-13 minutes), since it contains also the explanation and motivation why SP5 has been launched.

The Scripts

1. Create the Master Key:

 1: USE master;
 2: 
 3: go
 4: 
 5: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'n0PWStealingAll0w3d!';
 6: 
 7: go

2. Create the Certificate:

 1: CREATE CERTIFICATE SP5Certificate WITH SUBJECT = 'SP5 DEK Certificate';
 2: go
 3: 

 

3. Back up Certificate & Private Key (EXTREMELY IMPORTANT TO KEEP IT BACKUPPED AND SAFE!):

 1: USE master;
 2: go
 3: BACKUP CERTIFICATE SP5Certificate TO FILE = 'C:\Certificate\TDECertificate.cer'
 4: WITH PRIVATE KEY (
 5: FILE = 'C:\Certificate\PK.pvk',
 6: ENCRYPTION BY PASSWORD = '?pkP4SsW0rD!');
 7: GO

4. Create Database Encryption Key:

 1: CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE SP5Certificate;
 2: 
 3: GO

5. Enable Transparent Data Encryption for a Specific Content Database:

 1: CREATE CERTIFICATE SP5Certificate WITH SUBJECT = SP5Certificate;
 2: go

Please bear in mind:

  • Scripts need to be adapted to your needs, of course
  • Please run everything in a isolated test environment, before applying on production level
  • Consult your DBA before applying any changes to the SQL Server Instance, like running the beforementioned scripts.
  • The author of this blog cannot take responsibility for any damages caused by executing scripts, programs and configurations shown
  • It is your responsibility to inform yourself about possible side effects that are not reported. Usually, Technet and MSDN are good references for complete documentation of the concepts shown.
  • The scripts of SharePointFive are provided “as is”

Stay tuned till the next episode of SharePoint 5 and enjoy!

Best,

Martin

Read Full Post »

Dear all,

 

Shallow Copy is one of the new features added by the SharePoint Server 2010 SP1. Citing Microsoft, it does the following:

 

Shallow copy is a migration technique in which structured site collection data is moved across content databases while the unstructured data remains untouched in its originally configured BLOB store.

 

Sounds good, doesn’t it? In other words: The effort to migrate RBS-enabled site collections is greatly reduced – because we don’t have to consider the moving of the BLOB content anymore. Good!

 

The shallow copy can be performed using the Move-SPSite cmdlet, by simply specifying the RbsProviderMapping parameter. Here is an example:

 

Move-SPSite -Identity <Url> -DestinationDatabase <DB> 
–RbsProviderMapping @{"sourceProvider1"="targetProvider1",
"sourceProvider2"="targetProvider2"}

 

As stated before, only the structured content database is copied, while the unstructured content, such as BLOB files lying on file systems, remains untouched. Only the ownership information for the BLOB content is copied to the destination database.

 

Stay tuned till the next time!

Best regards,

Martin

Read Full Post »

1. Close Distance Rule:

Keep Web Frontends, Application Servers and Database Servers physically located as close as  possible.

 

Rule of thumb: No more than 1 ms of latency between WFEs/AS and DB servers. In practice, this means: WFEs/ASs should reside in the same data center as DB servers.

 

 

2. Co-Location/Separation of Databases

Certain databases must be co-located or ideally separated from other databases.

 

Rule of thumb: Separate the following databases:

 

 

 

image

Source: Microsoft Technet

 

Rule of thumb: Co-locate the following databases:

 

 

image

Source: Microsoft Technet

 

3. Constantly Monitor Database Servers

Size: Rules of thumb:

    Pre-grow databases and logs.

    Monitor disk space at all times.

    < 50 Databases per SQL Server instance (when mirroring)

                          < 200 GB per content database

 

 

Metrics: Rules of thumb:

    Network Queue: 0 or 1 for best performance

    Average Disk Queue length (latency) : < 5 ms

                       Memory used: < 70%

                       Free disk space: > 25%

                       Buffer cache hit ratio: >= 90%

 

4. Transaction Logs Backup

Rule of thumb: Back up and truncate the transaction logs every 5 minutes. Shrinking the transaction logs is not recommended since it will have a performance impact while it re-grows.

 

 

For preventing the transaction logs to grow unexpectedly, view the following KB: http://support.microsoft.com/kb/873235

 

That’s it for this time. Have fun configuring your DB servers for your SP2010 environment. As usual, no responsibility is taken for any damage that could occurr. And as ususal, I highly recommend trying all changes on a test environment and the adaptation to your specific IT infrastructure.

 

Enjoy and best regards,

Martin

Read Full Post »