The nighttime indexing job that used to take four hours? The Aftermath
“You’re giving me a disc ?” she asked.
Lena shook her head. “No. This is the Enterprise handshake. Watch.” sql server 2005 enterprise
The old 32-bit Standard server crashed when tempdb hit 1.7GB. SQL Server 2005 Enterprise on 64-bit addressed terabytes of RAM. Lena watched Performance Monitor as the buffer pool grew to 28GB. Every join, every hash match, every sort happened in memory.
She had created a snapshot just before lunch. The nighttime indexing job that used to take four hours
The TrackingEvents table had 1.2 billion rows. Old queries scanned entire months of data. Lena created a partition function by week, then aligned it to a partition scheme.
That winter, Northwind Solutions signed the contract. The CEO bought Lena a bottle of Macallan 18. Marcus got a raise. SQL Server 2005 Enterprise on 64-bit addressed terabytes
“It’s just SQL Server with more zeros, right?” Marcus asked, loading the media.