Wednesday, October 7, 2015

configuring the BLOB cache SharePoint Performance

BLOB cache needs to be enabled in the front end web server(IIS) and once configured; the frequent files used in sharepoint will be retrieved from the database and stored in a directory under Front end web server (IIS). This reduces the network traffic/load on the database server as the frequent files will be stored into disk .Got to WebApplication web.config file search for <BlobCache>

<BlobCache location="C:\BlobCache\14" path="\.(gif|jpg|jpeg|jpe|jfif|bmp|dib|tif|tiff|themedbmp|themedcss|themedgif|themedjpg|
|wmv|ogg|ogv|oga|webm|xap)$" maxSize="100" enabled="false" />

Sql Command to find product version and Edition

I was goggling for to find the current product version of Sql server several times in my environment .And I was the forget the query several times being human. So decided to save on web
            SERVERPROPERTY('ProductVersion') AS ProductVersion,
            SERVERPROPERTY('ProductLevel') AS ProductLevel,
            SERVERPROPERTY('Edition') AS Edition,
            SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime',
            SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion'