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
Which AWS Storage options work for SQL Servers? If you looking for AWS storage options for SQL Servers for your EC2 instance, your choices are limited. You can use EBS GP2 or EBS Provisioned IOPS – that’s it! Amazon has multiple storage options. It may be a bit confusing which to use for what purpose.
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 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 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
Why Disk (or Storage or I/O or R) operations matter the MOST when Tuning T-SQL Calls for Performance “Disk” – has different names. I think that confuses anyone outside of DBA little world. Alternate names some DBAs call Disk (including myself) are: Storage I/O (input output operations) Disk operations or simply “Reads” All of those
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,
Before vs. After Perf Tuning Report #9 – 1,600% gain Another tuning. Another significant gains. More details: Here is the Excel version.
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 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.
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 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