Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
My server has 1.5GB of physical memory, and I've assigned 1.3GB (650,000 2KB pages in sp_configure memory) to SQL Server. I've allocated 100MB of RAM to tempdb. Does that 100MB come from the memory I've already allocated to SQL Server...
In the March issue of Windows NT Magazine, I explored the options available for integrating SQL Server with Windows NT's Performance Monitor, a tool that can provide a comprehensive overview of your SQL Server system's behavior (see "7 Tips for H...
In Books Online (BOL), Example F of the xp_sqltrace entry contains a table similar to SQL Trace. Unfortunately, the example table contains two serious bugs you need to know about. The BOL SQL Trace Application column is defined as NOT NULL, which...