Skip to main content

Home/ Groups/ MS SQL Server and Analysis Services
Rss Feed
Sort By: Most Recent | Popular Filter: All | Bookmarks | Topics Simple Middle
1More

MSOLAP Service Crashes Once a Day - Windows Low Fragmentation Heap vs OLAP Heap - 0 views

jesseorosz.spaces.live.com/...cns!E322FD91218E57CF!295.entry SQL Server Analysis Services
shared by Sergey Leifer on 11 Aug 10 - Cached
  • Sergey Leifer on 31 Aug 10
     
    OLAP Heap isn't an stable as Windows, especially if you have a large OLAP database (we're 500GB and I guess that's considered large)...
1More

How to reduce paging of buffer pool memory in the 64-bit version of SQL Server - 1 views

support.microsoft.com/918483 SQL Server Management SQL2008
shared by Sergey Leifer on 31 Aug 10 - Cached
  • Sergey Leifer on 31 Aug 10
     
    ... SQL Server can use the memory notification mechanisms that are provided by the QueryMemoryResourceNotification Windows API. On a Microsoft Windows 2000 Server-based system, SQL Server periodically calculates the free physical memory on the system by using the native Windows API. Based on this information from the QueryMemoryResourceNotification Windows API or from the memory calculation, SQL Server responds to the current memory situation on a specific system...
1More

SQLDiag for SQL Server 2005 - 0 views

www.virtualobjectives.com.au/...sqldiag_2005.htm SQL Server Monitoring
shared by Sergey Leifer on 07 Aug 10 - Cached
  • Sergey Leifer on 31 Aug 10
     
    This article explains how to use SQLDiag as a Service to get more thorough diagnostics than the standard Profiler traces or Server Side Tracing...
1More

A closer look at CXPACKET wait type in SQL Server - 0 views

www.mssqltips.com/tip.asp SQL Server Monitoring
shared by Sergey Leifer on 07 Aug 10 - Cached
  • Sergey Leifer on 31 Aug 10
     
    If you have a server that has more than one CPU core, you may experience high values of CXPACKET wait types. This is typically due to queries that run in parallel and the real issue is to understand how different versions of a query can impact CXPACKET waits...

Automating Analysis Services Deployment - 1 views

started by Sergey Leifer on 29 Aug 10 no follow-up yet

T-SQL: disk free space alert - 0 views

started by Sergey Leifer on 29 Aug 10 no follow-up yet

SSAS performance counters - 0 views

started by Sergey Leifer on 29 Aug 10 no follow-up yet

SSAS performance counters - 0 views

started by Sergey Leifer on 11 Aug 10 no follow-up yet
1More

Security Checklists - 0 views

iase.disa.mil/checklist Security
shared by Sergey Leifer on 09 Aug 10 - Cached
  • Sergey Leifer on 09 Aug 10
     
    Security checklists for different products
‹ Previous 21 - 40 of 57 Next ›
Showing 20▼ items per page