Glen, really good information above, I just wondered if anyone else still suffered the memory leak even with the required CU in place? Servers deployed 6 weeks ago with 2008 R2 CU13 build version, no issues at all until this weekend when the production instance suddenly let go giving paging file too small errors, shared memory provider time-outs and memory leak warnings before the service terminated. That way, you are less likely to ever have any type of automatic statistics updating kick in at an inopportune time and you can tailor your statistics updating more appropriately for your workload
SQL Server 2008 R2 Setup Client Tools Connectivity - Database Administrators Stack Exchange
You may not need all of them installed and so you should think about what you really need before installing them as extra components increase the surface area of attack upon a system
Write one check, and you get a complete soup-to-nuts data warehouse storage engine that includes everything from the servers, SAN, configuration, and training. I asked what happens when a Parallel Data Warehouse system starts to have performance issues, and he explained that the DBA will need to call in specialized Parallel engineers
These improvements provide you with increased availability and performance, improved management, and simplified methods for deployment including live migration. The following improvements to IIS and the Windows Web platform are included in Windows Server 2008 R2: Reduced Effort to Administer and Support Web-Based Applications Reduced Support and Troubleshooting Effort Improved File-Transfer Services Ability to Extend Functionality and Features Improved .NET Support Improved Application Pool Security IIS.NET Community Portal Learn more about the Web Application Platform in Windows Server 2008 R2
What is for sure is that if you haven't shelled out the money for Oracle Enterprise and Oracle Spatial, Oracle still doesn't think you are worthy enough to do a union or intersection of any kind at all even in the 11GR2 offering, so the discussion is kind of moot if you are using Oracle Locator. On the Oracle side -- presumably if you are running a PeopleSoft or Oracle Financials and had a need for spatial support, it may be easier with Oracle database
Once you install the Reporting Services Add-in and configure your servers for integration, you can publish Reporting Services content to a SharePoint library and then view and manage those documents directly from a SharePoint site. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 R2 features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API
Once you install the Reporting Services Add-in and configure your servers for integration, you can publish Reporting Services content to a SharePoint library and then view and manage those documents directly from a SharePoint site. Data Mining Client for Excel: This add-in enables you to go through the full data mining model development lifecycle within Excel 2007 using your spreadsheet data or external data accessible through your SQL Server 2008 Analysis Services instance
SQL Server 2008 R2 Build List - SQLServerCentral
Major Builds Build KB Article Title Description 10.50.6000 2979597 Service Pack 3 for SQL Server 2008 R2 Final Service Pack for SQL Server 2008 R2 10.50.4000 2630458 Service Pack 2 for SQL Server 2008 R2 The second roll-up of patches into a service pack for SQL Server 2008 R2. 10.50.1600 RTM Release of Manufacturing of SQL Server 2008 R2 The first public, supported version of SQL Server 2008 R2 Note that Service Packs include all builds below that Service Pack level
If you have have a fresh install of SQL Server 2008 R2, you just have to download and install SP2 and there is no need to install SP1 as this service pack is cumulative SP and contains all the previous upgrades of SP1. Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account
He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events
Aaron Bertrand : SQL Server 2008 R2 Service Pack 1 is now available
He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events. Why should they download a file twice the size if they're not going to use half of it? While I agree that their naming scheme is not perfect, but I think it is relatively intuitive that if you have *just* Management Studio, you download the patch that has Management Studio in the name, and if you have more than that, you download the full service pack
No comments:
Post a Comment