SQL Managed Instance is one of the latest addition to the Azure SQL Database family of PaaS offering in Azure. Azure SQL Database, besides representing the singleton SQL databases in Azure, also represents the family of managed relational databases services in Azure. If you have not heard of Azure SQL Managed Instance before, I would highly… Continue reading Architecting Azure SQL Managed Instance solutions
Upgrade your SQL Server to scale before adding new hardware
In SQL Server Tiger team, we closely partner with our customers and partners to ensure they can successfully run and scale their Tier 1 mission critical workloads and applications on SQL Server. Based on our experience and interactions with customers, we found that most customers running older releases of SQL Server and experiencing performance and… Continue reading Upgrade your SQL Server to scale before adding new hardware
Smart Transaction log backup, monitoring and diagnostics with SQL Server 2017
Smart Transaction Log Backups Most DBAs today operating their SQL Server database in full recovery model, schedule their transaction log backups to recur on a specific time interval (every 15 mins) for a highly transactional database to avoid autogrowth of the transaction log files. This works well assuming transactional activity is consistent or predictable throughout… Continue reading Smart Transaction log backup, monitoring and diagnostics with SQL Server 2017
Considerations when tuning your queries with columnstore indexes on clone databases
As discussed in my previous blog post, one of the primary scenario for DBCC CLONEDATABASE is to assist dbas, developers and support teams in troubleshooting sub-optimal query plans by creating fast, minimally invasive and transaction ally consistent database clones of their production databases. The database clone created using DBCC CLONEDATABASE contains the copy of schema… Continue reading Considerations when tuning your queries with columnstore indexes on clone databases
Understanding data security in cloned databases created using DBCC CLONEDATABASE
DBCC CLONEDATABASE feature was first introduced in SQL Server with SQL Server 2014 SP2 and was later added to SQL Server 2016 with SP1. The primary design goal for DBCC CLONEDATABASE which the SQL Product team had in mind is to provide mechanism to create fast, minimally invasive and transaction ally consistent database clones, useful… Continue reading Understanding data security in cloned databases created using DBCC CLONEDATABASE
SQL Server Performance Baselining Reports Unleashed for Enterprise Monitoring !!!
In my previous blog post, I had shared how you can leverage SQL Server Performance Dashboard SSRS Reports for monitoring and point in time troubleshooting for large deployments of SQL Server. In this post, we will talk about why dbas should establish SQL Server Performance baselines for their environment and how you can leverage the… Continue reading SQL Server Performance Baselining Reports Unleashed for Enterprise Monitoring !!!
Remote Blob Storage (RBS) client library setup requirements in SQL Server 2016
Cross post from https://blogs.msdn.microsoft.com/sql_server_team/remote-blob-storage-rbs-client-library-setup-requirements-in-sql-server-2016/ Remote BLOB Store (RBS) is a client library with SQL Server which allows developers to store, access, retrieve binary large objects (BLOBs) outside SQL Server database files while still maintaining the ACID properties and transactional consistency of data in Blob store. RBS allows you to efficiently utilize storage and IO resources… Continue reading Remote Blob Storage (RBS) client library setup requirements in SQL Server 2016
Boosting Update Statistics performance with SQL 2014 SP1/CU6
Cross post from https://blogs.msdn.microsoft.com/sql_server_team/boosting-update-statistics-performance-with-sql-2014-sp1cu6/ With SQL 2005 end of life, many customers are planning their upgrades to SQL 2014. One of the recommended post upgrade tasks is updating the statistics of all the tables and databases in latest compatibility level. The updated statistics ensures the new optimizer in the latest release has most up to… Continue reading Boosting Update Statistics performance with SQL 2014 SP1/CU6
SQL Server Datafile maxsize reported incorrectly
Recently we encountered and filed a benign reporting BUG which reports the maxsize of the data file incorrectly. If you create a database & then alter the initial size of the database to be greater than maxsize & then query sys.database_files, sys.master_files, sysaltfiles the maxsize appears to be incorrectly reporting the older value of maxsize.… Continue reading SQL Server Datafile maxsize reported incorrectly
Columnstore Indexes and Statistics
Until the introduction of Columnstore indexes, most DBAs didn’t care much about the creation of statistics on the indexed columns as the statistics are auto created on the indexed columns when the index is created. With Auto Create Statistics turned ON for the database, the optimizer will automatically trigger the creation of statistics when it… Continue reading Columnstore Indexes and Statistics