SqlServerKudos

Memory

1
kudos

Kudos

SQL Server performance series: PAGELATCH_ and PAGEIOLATCH_ wait types: relates to concurrency, take steps in diagnosing and resolving latch contention issues.

published 100 days, 3 hours, 45 minutes ago posted by

sa 109 days, 4 hours, 36 minutes ago

SQL Server performance series: PAGELATCH_ and PAGEIOLATCH_ wait types: relates to concurrency, take steps in diagnosing and resolving latch contention issues.

Contention is the word that you need to concentrate in resolving the performance issue, page latches contention is common in multi-CPU systems due to the nature of w hen multiple threads concurrently attempt to acquire incompatible latches to the same in-memory structure. Going back to basiscs a latch is an internal mechanism that is used by SQL DB engine automaticatlly to determine when to use it. By design they are deterministic and any behavior of schema design can affect the issue.One of the...(read ... (more)

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

tags: buffers, cpu, DBA, dmvs, Memory, pageiolatch, perfmon, Performance, performance monitoring, SQL Server, tuning, wait stats

1
kudos

Kudos

SQL Server BI Development practices: streamline the project deployment using tools

published 150 days, 8 hours, 2 minutes ago posted by

sa 158 days, 8 hours, 17 minutes ago

SQL Server BI Development practices: streamline the project deployment using tools

When you talk about Business Intelligence (BI) the key aspect of this arena is development, all the way you need to ensure that the design and development is thorougly following the aspects of the solution. In this scenario the deployment comes handy where you frequently deploy the project to a development server for unit testing in order to create AS databases defined by the project. Most of the coding can be handled using .NET technology, at the end you must ensure to data storage where the Analysis...... (more)

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

tags: Analysis Services, benchmarking, Best Practices, cpu, Hardware, Memory, parallel processing, Performance, profiler, SAN, SQL Server, ssd

1
kudos

Kudos

How to change default path for SQL Server Reporting Services log file?

published 166 days, 9 hours, 13 minutes ago posted by

sa 176 days, 8 hours, 53 minutes ago

How to change default path for SQL Server Reporting Services log file?

When you install the SQL Server Reporting Services (SSRS) to develop and manage the reports efficiently, there are certain default settings that needs to be changed based on the enterprise requirement. For instance when the SSRS is installed then the next step is to configure the report server isntance that can tune the installation to provide additional features or configure the system settings as scalable environment. Say if you need to configure the RS to use a custom style sheet, then the valid...(re... (more)

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

tags: config file, configuration, error log, folder, Memory, report manager, report viewer, SQL Server

1
kudos

Kudos

SQL Server performance practices: Max Worker Threads, don't touch it #sql #sqlperf

published 264 days, 16 hours, 18 minutes ago posted by

sa 269 days, 16 hours, 43 minutes ago

SQL Server performance practices: Max Worker Threads, don't touch it #sql #sqlperf

When you are dealing with multi-instances and multiple databases then handling server resources is essential. By default every instance of SQL Server runs as a seperate system process, in terms of memory. In such cases each instance will need to handle concurrent requests from the applications and that instance need to start a thread on operating system is created which is then allocated to specific CPU. The distribution of threads and CPUs is managed automatically by the operating system and SQL...(read... (more)

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

tags: Best Practices, cpu, DBA, i/o, Maintenance, max worker threads, Memory, package, Performance, performance monitoring, pressure, SQL Server

1
kudos

Kudos

SQL Server Analysis Services: Multi-level hierarchy dimension design gotchas

published 306 days, 19 hours, 11 minutes ago posted by

sa 315 days, 19 hours, 56 minutes ago

SQL Server Analysis Services: Multi-level hierarchy dimension design gotchas

Dimension design is an important aspect to build the Business Intelligence around the data within the data platform. Just on bascis, on OLAP world the database dimension is treated as colleciton of related objects (referred as attributes) that can provide required information about factual data in cubes. By default these objects are bound to one or more columns in one or more tables in a data source view. The attributes can be arranged as hierarchies that will help to navigate the user path when...(read ... (more)

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

tags: attributes, benchmarking, Best Practices, cpu, Cube, DBA, diagnose, Dimension, Memory, Performance, SQL Server, wizard

1
kudos

Kudos

SQL Server virtualization - Hyper-V and Live Migration, interesting concept for server consolidation

published 315 days, 19 hours, 51 minutes ago posted by

sa 324 days, 20 hours, 34 minutes ago

SQL Server virtualization - Hyper-V and Live Migration, interesting concept for server consolidation

Virtualization is a hot topic to discuss and essentail to consider when you are referring to server consolidation to save physical sprawl & costs. The consolidation project will typically start to achieve the mile-stones such as reducing the operations expenditure by considering lack of space in the data center, reduce costs, centralization and Green IT(buzzword). However consolidation is not a final answer for all the applications, in case of mission-critical applications a dedicated environment...(read... (more)

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

tags: Best Practices, consolidation, data center, enterprise, live migration, Memory, Performance, Scalability, SQL Server, Virtualization

1
kudos

Kudos

SQL Server Performance series: Parallel query processing gotchas

published 324 days, 20 hours, 29 minutes ago posted by

sa 333 days, 21 hours ago

SQL Server Performance series: Parallel query processing gotchas

Parallel query processing is one of the best performance features available from SQL Server 2008 version onwards. By default Microsoft documentation suggests to change MAXDOP settings remain equal to number of physical processors that are being used on the server. Further that suggestion is documented in KBA322385 article too, but it may not be an optimal solution for all the server environments as every installation & environment is different to each other on top of physical hardware configuration...(re... (more)

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

tags: DBA, maxdop, Memory, numa, Performance, Processes, resource governor, SQL Server, statiscs age, worker threads

1
kudos

Kudos

SQL Server Memory gotchas within Windows 2003 and Windows 2008 enviornment, issues and problems

published 386 days, 23 hours, 57 minutes ago posted by

sa 395 days, 1 hour, 24 minutes ago

SQL Server Memory gotchas within Windows 2003 and Windows 2008 enviornment, issues and problems

On a peaceful friday night had a pager for a severed problem in one of the SQL Server instances! When I looked at the error not a good one, preliminary message from alerting software was " Description: The SQLBrowser service was unable to process a client request ". After a peek on SQL error log revealed the nightmare and the text goes " SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for...(rea... (more)

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

tags: 64 bit, error log, issues, kba, Memory, operating system, paged, Performance, spawn threads, SQL Server, worker threads, working set

2
kudos

Kudos

SQL Server DMVs - where to start and how to use?

published 500 days, 8 hours, 48 minutes ago posted by

sa 509 days, 10 hours, 16 minutes ago

SQL Server DMVs - where to start and how to use?

When you need to troubleshoot a problem, prior to SQL Server 2005 you have to depend upon PROFILER or query system tables constantly or some other means to trace the system usage. SQL Server 2005 onwards DBAs are equipped with Dynamic Management Views (and Data Mining Extenstions DMX for Analysis Services) for core database engine to obtain the snapshot of information on resource usage such as disk, cpu, memory and many more. The 2 types of DMVs are server-scoped & database scoped whics requires...(read ... (more)

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

tags: beginner, Best Practices, DBA, disk space, DMV, Memory, Performance, performance tuning, resource, SQL Server, system, troubleshoot

1
kudos

Kudos

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

published 562 days, 13 hours, 11 minutes ago posted by

sa 571 days, 13 hours, 57 minutes 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 566 days, 13 hours, 27 minutes ago posted by

sa 575 days, 15 hours, 22 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 568 days, 13 hours, 37 minutes ago posted by

sa 578 days, 10 hours, 53 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 578 days, 14 hours, 18 minutes ago posted by

sa 585 days, 15 hours, 43 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 635 days, 18 hours, 33 minutes ago posted by

sa 644 days, 21 hours, 9 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 702 days, 22 hours, 28 minutes ago posted by

sa 710 days, 1 hour, 4 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 721 days, 23 hours, 54 minutes ago posted by

sa 728 days, 14 hours, 39 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 764 days, 6 hours, 14 minutes ago posted by

sa 773 days, 18 hours, 21 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 838 days, 12 hours, 32 minutes ago posted by

sa 848 days, 1 hour, 7 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 859 days, 13 hours, 57 minutes ago posted by

sa 862 days, 5 hours, 47 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 869 days, 14 hours, 42 minutes ago posted by

sa 879 days, 5 hours, 8 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

Welcome!

Memory

SQL Server performance series: PAGELATCH_ and PAGEIOLATCH_ wait types: relates to concurrency, take steps in diagnosing and resolving latch contention issues.

SQL Server BI Development practices: streamline the project deployment using tools

How to change default path for SQL Server Reporting Services log file?

SQL Server performance practices: Max Worker Threads, don't touch it #sql #sqlperf

SQL Server Analysis Services: Multi-level hierarchy dimension design gotchas

SQL Server virtualization - Hyper-V and Live Migration, interesting concept for server consolidation

SQL Server Performance series: Parallel query processing gotchas

SQL Server Memory gotchas within Windows 2003 and Windows 2008 enviornment, issues and problems

SQL Server DMVs - where to start and how to use?

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

Open ID Login

Standard Login

Forgot Password?

Sign up