Results


Optimization tips and tricks on Azure SQL Server for Machine Learning Services

#artificialintelligence

By using memory-optimized tables, resume features are stored in main memory and disk IO could be significantly reduced. If the database engine server detects more than 8 physical cores per NUMA node or socket, it will automatically create soft-NUMA nodes that ideally contain 8 cores. We then further created 4 SQL resource pools and 4 external resource pools [7] to specify the CPU affinity of using the same set of CPUs in each node. We can create resource governance for R services on SQL Server [8] by routing those scoring batches into different workload groups (Figure.