Check the Available Memory of Default Pool

One capacity planning best practice of using SQL In-Memory OLTP engine is to bind the database with a resource governance pool. The calculation of memory resource of pools is from here, and I translate it into below TSQL code  to check both configured value and available value in run time.

0

Extract all the connection strings from SSIS packages

One important task in SSIS upgrade/migration project is the assessment of data provider types, source and destination connection strings in the all packages. The output is used to understand which data source and destination are involved, which data providers are in used. You could use SSDT to check SSIS package but you need a quicker way if the number…

0

Consideration of Hardware Resource Sharing

After the change of SQL Server license scheme, many of my customers are asking help to consolidate their SQL to maximize the investment of hardware/software. There are 3 methods to share the hardware resource: Method 1: One SQL Server instance shared by multiple databases Method 2: One Windows/Cluster shared by multiple SQL Server instances Method…

0