How to use SQL Server FILESTREAM feature for large databases

Do’s and don’ts   What is SQL Server FileStream feature? This feature allows adding unstructured documents into the database. You can store images, PDFs, videos, or whatever files you want into SQL Server database. This allows to have transactional consistency of images.   We have worked with very large FILESTREAM implementation. And I will show

sql performance
Blog
Mark Varnas

How to Eliminate SQL Server Migrations Performance Risks with DReplay

using THE LEAST USED SQL feature called Distributed Replay (DReplay) There are a lot of things that can go wrong during SQL migration. One of them – random TSQL calls which become slower. And they do. Here is an actual example where we tested two SQL Server configurations prior to SQL Upgrade and Migration. In

How to re-initialize SQL Server Merge replication publication

How to re-initialize SQL Server Merge replication publication 1. Connect to publisher instance: CIXSQL01\TOUCHSTORE. 2. Click right on Replication folder and click on “Launch Replication Monitor” option. 3. Click right on publication that you want to reinitialize and click on “Generate Snapshot” 4. After generating the snapshot go back to Local Replication, expand the publication

Before vs. After Perf Tuning Report #11 – 767,508% improvement

Before vs. After Perf Tuning Report #11 – 767,508% improvement This is the case when tuning sometimes can not be done perfectly. We trying to change DB code, so nothing else needs to change. In some cases, even though result set is exactly same, rows may come back in the different order back to the

Before vs. After Perf Tuning Report #10 – 340% CPU gain

Before vs. After Perf Tuning Report #10 – 340% CPU gain This tuning requires a bit of a different explanation. In some cases, client server is pressure on different resources. The three resources/parameters when tuning we care most about are: CPU Storage Duration In this case, this stored procedure ran a LOT. It ran enough,

How to configure Antivirus running on SQL Server

How to configure Antivirus running on SQL Server   First, I’d question having Antivirus on SQL Server if it is a “must have”. Then question it again. Seriously. Not joking.   SQL Servers are often internal. Behind firewalls. Not accessible from outside. Only accessible by internal apps. Therefore, it may not make sense to run

12 SQL Server Monitoring Jobs

12 SQL Server Monitoring Jobs and the best SQL monitoring practices even if Santa brought you all third party software licenses you asked fir   I don’t care how many third party software monitoring you got going on. Some alerts work best as SQL native tools.   SQL DBA are responsible to many SQL Servers.

Applying SQL Server and Windows patches to AlwaysOn clusters – Best Practices

How to apply Windows or SQL Server patches to failover SQL Server cluster with AlwaysOn – Step by step Apply patches to lower environment servers first. This is DEV, QA, UA, etc. Use the lowest environment in the release cycle. Let the new change “burn in” for a while. The “while” depends per client. Some

Before vs. After Perf Tuning Report #8 – 913,262% speed improvement

Before vs. After Perf Tuning Report #8 – 913,262% speed improvement Total improvement: 913,262% Not bad, huh? These type of database speed improvements makes me smile! 🙂   Here is another SQL Server performance tuning report. Before vs. After. “Before” – shows numbers before we made any changes. “After” – shows performance numbers after we