Nice article talking about the best practice of running SQL server on Hyper-V: http://mssqldude.wordpress.com/2011/11/02/sql-server-virtualization-recommendations-on-hyper-v/ Lock Pages in Memory. In fact, this is quickly becoming a STANDARD recommendation on all SQL Server boxes and VMs that are dedicated as database servers. Virtual SCSI-attached virtual disks for all data disks give the best performance for SQL Server. … Continue reading SQL Server Virtualization Recommendations on Hyper-V
TSM Path Failover
I noticed that TSM is unable to handle the redundant path to the tape library. As the path to the library is hardcoded in the configuration something like: def libr TS3500 libtype=SCSI def path TSMServer TS3500 srct=server destt=library device=lb4.1.0.5 But if you are lucky, the path failover can be handled by the device drivers. In … Continue reading TSM Path Failover
Understanding BLOB
To solve the storage problem of large files in SQL server. Some smart guys developed the BLOB concept, it stands for Binary Large Object. From the following diagram, you can see that the large files are stored in the DB table when there is no BLOB provider applied. This definitely will decrease the database performance … Continue reading Understanding BLOB
Preparing to Install or Upgrade to BE 2012
BE 2012 is quite a radical break from earlier versions of BE and as such, you should do more preparations and testing before you install or upgrade to BE 2012. Otherwise, you may have a nasty surprise. http://www.symantec.com/connect/articles/preparing-install-or-upgrade-be-2012?om_ext_cid=biz_con_email_2012_may16_news_install
Data Deduplication Best Practices for Tivoli Storage Manager V6.2
If you use the data deduplication feature of Tivoli Storage Manager, I would recommend you to read the following article, very helpful! Original Link: http://www.ibm.com/developerworks/wikis/display/tivolistoragemanager/Data+deduplication+best+practices+for+Tivoli+Storage+Manager+V6.2 Introduction Data deduplication technology that was introduced in Tivoli Storage Manager V6.1 and further enhanced with source-side (client) deduplication in Tivoli Storage Manager V6.2 provides the following two primary benefits: … Continue reading Data Deduplication Best Practices for Tivoli Storage Manager V6.2