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|
themedpng|ico|png|wdp|hdp|css|js|asf|avi|flv|m4v|mov|mp3|mp4|mpeg|mpg|rm|rmvb|wma
|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
SELECT
            SERVERPROPERTY('ProductVersion') AS ProductVersion,
            SERVERPROPERTY('ProductLevel') AS ProductLevel,
            SERVERPROPERTY('Edition') AS Edition,
            SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime',
            SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion' 

GO