SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

cpu

1
kudos

Kudos

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

published 49 days, 13 hours, 25 minutes ago posted by

sa 58 days, 14 hours, 11 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 53 days, 13 hours, 40 minutes ago posted by

sa 62 days, 15 hours, 35 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 55 days, 13 hours, 50 minutes ago posted by

sa 65 days, 11 hours, 6 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 65 days, 14 hours, 31 minutes ago posted by

sa 72 days, 15 hours, 56 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 122 days, 18 hours, 46 minutes ago posted by

sa 131 days, 21 hours, 22 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 224 days, 4 hours, 22 minutes ago posted by

sa 233 days, 12 hours, 16 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 325 days, 12 hours, 45 minutes ago posted by

sa 335 days, 1 hour, 20 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 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 356 days, 14 hours, 55 minutes ago posted by

sa 366 days, 5 hours, 21 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

SqlServerKudos

Welcome!

cpu

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