To extend functionality and create more robust Extensible Markup Language (XML) solutions for its customers, Bluestone Software signed complementary product agreements with Cloudspace, Extensibility, Fiorano Software, PointBase, and Vervet Logic...
A. First make sure that you have actually expanded tempdb - as it defaults to 2Mb on the master device only. Create new device(s) for it and expand it onto these devices. Do NOT expand it on master...
A. This is because "page faults" are NOT the same as paging to disk. A page fault occurs every time SQL accesses a page in memory that is outside it's "working set". Due to the way that the SQL performance monitor counters work in SQL 6.5 and...