SqlServerKudos

cpu

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, 39 minutes ago posted by

sa 109 days, 4 hours, 29 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, 7 hours, 55 minutes ago posted by

sa 158 days, 8 hours, 10 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

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

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

sa 269 days, 16 hours, 36 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, 4 minutes ago posted by

sa 315 days, 19 hours, 49 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 Perf: What is the optimal disk or data file placement configuration layout for better performance?

published 484 days, 7 hours, 34 minutes ago posted by

sa 493 days, 9 hours, 31 minutes ago

SQL Server Perf: What is the optimal disk or data file placement configuration layout for better performance?

SQL Server manages when and how disk I/O is performed, but the Windows operating system performs the underlying I/O operations. The I/O subsystem includes the system bus, disk controller cards, disks, tape drives, CD-ROM drive, and many other I/O devices. Disk I/O is frequently the cause of bottlenecks in a system. Having said that SQL Server uses the specific storage ages of TEMPDB, Transaction log file and database files, whereever you see the best practice always dictate that seperating TEMPDB...(read... (more)

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

tags: alignment, benchmarking, Best Practices, core, cpu, DBA, disk, raid, SQL Server, storage, tempdb

1
kudos

Kudos

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

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

sa 571 days, 13 hours, 51 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, 20 minutes ago posted by

sa 575 days, 15 hours, 15 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, 30 minutes ago posted by

sa 578 days, 10 hours, 46 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, 11 minutes ago posted by

sa 585 days, 15 hours, 37 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, 26 minutes ago posted by

sa 644 days, 21 hours, 2 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

List of SQL Server 2008 Enterprise Edition Knowledge Base Notification update

published 737 days, 4 hours, 3 minutes ago posted by

sa 746 days, 11 hours, 56 minutes ago

List of SQL Server 2008 Enterprise Edition Knowledge Base Notification update

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications FIX: The LogReader agent unexpectedly consumes all CPU resources when the agent handles a failed connection in a SQL Server 2008 transactional replication http://support.microsoft.com/kb/976991/en-US FIX: Only the first 2000 characters are returned by the fn_get_audit_file() function when you use it to obtain the information of an audit...(rea... (more)

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

tags: cdc, change data capture, cpu, data files, enterprise edition, kba, SQL Server, SSIS

1
kudos

Kudos

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

published 838 days, 12 hours, 25 minutes ago posted by

sa 848 days, 1 hour 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 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, 35 minutes ago posted by

sa 879 days, 5 hours, 1 minute 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!

cpu

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

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 Perf: What is the optimal disk or data file placement configuration layout for better performance?

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

List of SQL Server 2008 Enterprise Edition Knowledge Base Notification update

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

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