SqlServerKudos

Memory

1
kudos

Kudos

SQL Server and Windows Server R/2008 version: Physical Resources support for high-end systems

published 9 days, 5 hours, 15 minutes ago posted by

sa 18 days, 6 hours, 1 minute ago

SQL Server and Windows Server R/2008 version: Physical Resources support for high-end systems

SQL Server 2008 R2 and Windows Server 2008 R2 has opened up new dimension of physical resource usage and limitations. As you may be aware Windows Server 2008 R2 is only available in 64-bit edition, having the features that are related to DB engine are changed in SQL Server 2008 R2. The high specificiation of physical resources you talk that refers to the highest edition of SQL Server which is Enterprise Edition and with R2 it is Data-Center edition. COming back to subject line I had to look at BOL...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: awe, Best Practices, cpu, edition, features, ia64, Memory, physical resource, SQL Server, Upgrade, x64

1
kudos

Kudos

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

published 13 days, 5 hours, 30 minutes ago posted by

sa 22 days, 7 hours, 25 minutes ago

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

How many times have you taken help from SQL Server DMVs? How many of them are useful for your day-to-day data platform management? Well, they are closely attached to my day-to-day work. I'm excited to get my hands on upcoming client's project about their SQL Server platform review on the aspects of providing roadmap for the data-tier form a performance & scalability aspects with an additional flavour of high availability. In such scenarios I always keep my DBA-toolkit (scripts & references)...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: best practice, cpu, database user, DBA, DMV, Memory, server scope, SQL Server, SQL Server 2008 R2, sys.dm_os_

1
kudos

Kudos

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

published 15 days, 5 hours, 40 minutes ago posted by

sa 25 days, 2 hours, 56 minutes ago

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

SQL Server 2008 R2 has opened gates for endless opportunities for Organisations & Developers to take advantage of newest technologies. I'm getting to know these new features such as PowerPivot Features , the technical documentation refers that PowerPivot workbooks are like Excel workbook (.xslx) files that contain large, related datasets that you build in a separate PowerPivot window in Excel, and use with PivotTables and PivotCharts in a worksheet. This add-in can be downloaded from MS download...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, configuration, cpu, Installation, Memory, multiple, powerpivot, resources, server, SharePoint, SQL Server

1
kudos

Kudos

SQL Server has encountered '%' occurrence(s) of cachestore flush for the '%' cachestore

published 25 days, 6 hours, 21 minutes ago posted by

sa 32 days, 7 hours, 47 minutes ago

SQL Server has encountered '%' occurrence(s) of cachestore flush for the '%' cachestore

Do you watch/review the informationa messages that are generated in SQL Server error log? Do you have a alert mechanism to capture informational/warning/error messages within your data platform? The first question itself catered as informational, I believe at ceratin messages are supressed that are generated from application. But you should not attempt to supress such messages generated from SQL Server. For instance the one on subject line " SQL Server has encountered '%' occurrence(s) of cachestore...(r... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: cpu, dbcc freeproccache, free space, Memory, perfmon, performance monitoring, procedure cache, SQL Server, statiscs age, system

1
kudos

Kudos

SQL Server in Virtual platform - keep a close watch on physical server's configuration

published 82 days, 10 hours, 36 minutes ago posted by

sa 91 days, 13 hours, 12 minutes ago

SQL Server in Virtual platform - keep a close watch on physical server's configuration

Server consolidation & virtualization is a hot topic and also it is one of the biggest concerns for many DBAs is scalability/performance when it comes to virtualization. At this point,performance for virtual machines can be close to, if not the same as, many physical server configurations. Just not in case if you have multiple SQL instances, its fuel to problem. Also the DBAs cannot ignore the fact that Virtualization is advantageous for the company and consolidation gets flexibility to manage...(read more) (more)

category: News | clicked: 2 | comment | | source: sqlserver-qa.net

tags: Best Practices, configuration, cpu, DBA, disk, hyper-v, i/o, Memory, partition, Performance, SQL Server, virtual

1
kudos

Kudos

SQL Server Memory Cache - take help of DMV for optimal query plans

published 149 days, 14 hours, 32 minutes ago posted by

sa 156 days, 17 hours, 7 minutes ago

SQL Server Memory Cache - take help of DMV for optimal query plans

SQL Server query optimization and keepup of performance is not a black-art, it can be achieved in a fair manner if you treat your queries with plans with a are reused or recompiled plans that can help you design well-performing applications. There are ways to add a plan or data to the SQL Server cache or to remove a plan or data from SQL Server cache, but these techniques are only recommended for testing or troubleshooting purposes. The key point is more you understand about optimal query plans,...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benchmarking, best practice, BOL, cache, configuration, Memory, plan guide, Query, Security, SQL Server, technet

1
kudos

Kudos

SQL Server - SSIS package transformation performance issues, follow up

published 168 days, 15 hours, 58 minutes ago posted by

sa 175 days, 6 hours, 42 minutes ago

SQL Server - SSIS package transformation performance issues, follow up

To followup from The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure blog post, here are few findings that I would like to share. When you see that SQL Server instance throws the error as per above blog post, the amount of memory that can trigger this issue varies for different computers. If the package is really handling huge number of rows such as millions of rows during import/export operations, then allocate...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benchmarking, Best Practices, etl, Memory, Monitoring, perfmon, Performance, SQL Server, task manager

1
kudos

Kudos

Business Intelligence - how to determine the configuration settings for a data mart or warehouse project - notes from field

published 210 days, 22 hours, 17 minutes ago posted by

sa 220 days, 10 hours, 24 minutes ago

Business Intelligence - how to determine the configuration settings for a data mart or warehouse project - notes from field

Fast query response times and timely data refresh are two well-established performance requirements of Online Analytical Processing (OLAP) systems and to provide fast analysis, OLAP systems traditionally use hierarchies to efficiently organize and summarize data. The content of data warehouse (OLAP) database changes infrequently compared to that of transactional database (OLTP). By default the architecture and charter of data warehouse, the storage requirements increase over time and frequently reach...(... (more)

category: News | clicked: 3 | 1 comment | | source: sqlserver-qa.net

tags: Best Practices, business intelligence, i/o, Memory, olap, readonly, Security, settings, SQL Server

1
kudos

Kudos

How SQL Server 2008 can help to build fast track data warehouse?

published 285 days, 4 hours, 35 minutes ago posted by

sa 294 days, 17 hours, 10 minutes ago

How SQL Server 2008 can help to build fast track data warehouse?

Beginning of this year I have posted here about Build your BI skills in fast track data warehouse and based on that I have had few questions and feedback on how best we can take help of SQL Server 2008 features to build the fast track data warehouse. Based on the material and resources available on Microsoft site the approach must be on data access layer, configuration (hardware, software) and maintaining the normalization practices.When you talk about Business Intelligence then data access layer...(read... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: access, attributes, cpu, data warehouse, disk, fast track, Memory, Performance, SQL Server

1
kudos

Kudos

SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring

published 306 days, 6 hours ago posted by

sa 308 days, 21 hours, 50 minutes ago

SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring

Do you consider the I/O whenever a database design project is assigned? It is one of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. Over the time it may be one of the criteria that extensive usage of data and defautl behaviour on SQL Server builds a buffer pool in memory to hold pages read from the database. While queries are getting designed the code must be optimized and dedicated to minimizing...... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: capacity, disk, i/o, input, Memory, Monitoring, Performance, SQL Server, statistics, Tools

1
kudos

Kudos

SQL Server Security, Performance & Tuning (SSQA.net) : SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance

published 316 days, 6 hours, 45 minutes ago posted by

sa 325 days, 21 hours, 11 minutes ago

SQL Server Security, Performance & Tuning (SSQA.net) : SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance

The subject line of this post is a common factor that every DBA might have (once in lifetime). Performance Monitoring is a big subject when it comes to practice, many factors include such as what to monitor, how often, and 'basic' rules of thumb. For the sake of performance you cannot simply compromise any SLA or Availability of application, there needs to be an effective approach to monitor and manage Database Maintenance issues in specific to DBCC,... (more)

category: News | clicked: 2 | comment | | source: sqlserver-qa.net

tags: applications, Best Practices, cpu, DMV, dynamic, kerberos, maintenance plan, Memory, performance monitoring, sla, SQL Server

1
kudos

Kudos

Memory: Large Pages and MemToLeave

published 317 days, 6 hours, 50 minutes ago posted by

sa 326 days, 1 hour ago

I'm constantly surprised by the number of people that don't follow the CSS SQL blog - some of the best SQL people in the industry post there. I just revisited a couple of really interesting posts by my good friend Bob Ward on memory management internals that I'd like to publicize. (more)

category: News | clicked: 13 | comment | | source: www.sqlskills.com

tags: Inside the Storage Engine, Memory

Welcome!

Memory

SQL Server and Windows Server R/2008 version: Physical Resources support for high-end systems

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

SQL Server has encountered '%' occurrence(s) of cachestore flush for the '%' cachestore

SQL Server in Virtual platform - keep a close watch on physical server's configuration

SQL Server Memory Cache - take help of DMV for optimal query plans

SQL Server - SSIS package transformation performance issues, follow up

Business Intelligence - how to determine the configuration settings for a data mart or warehouse project - notes from field

How SQL Server 2008 can help to build fast track data warehouse?

SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring

SQL Server Security, Performance & Tuning (SSQA.net) : SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance

Memory: Large Pages and MemToLeave

Open ID Login

Standard Login

Forgot Password?

Sign up