SqlServerKudos - Stories tagged with benchmarking

benchmarking

atom rss
1
kudos
spam Kudos Remove

SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory
published 68 days, 7 minutes ago posted by sasa 71 days, 52 minutes ago
Tuesday, November 29, 2011 3:57:46 AM GMT Saturday, November 26, 2011 3:12:58 AM GMT
SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory
A discussion about trace flags 845 lead to explain the information about the requirement and necessity in case of 32 bit and 64 bit environments. The Lock Pages in Memory has gained importance since version 2005 due to the fact that 32-bit and 64-bit environments are managed. As you may be aware it was only available in Enterprise and Developer editions, since CU4 for SQL Server 2005 SP3 and CU2 for SQL Server 2008 SP1 it is enabled as a trace flag 845 for Standard Edition environment too. Lock Pages...(... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: benchmarking, Best Practices, configuration, cumulative update, lock down, lock pages in memory, performance monitoring, Security, SQL Server, Version
1
kudos
spam Kudos Remove

Analysis Services database and OLAP systems: building and tuning for the best possible performance
published 101 days, 4 hours, 1 minute ago posted by sasa 110 days, 4 hours, 52 minutes ago
Thursday, October 27, 2011 12:04:05 AM GMT Monday, October 17, 2011 11:13:10 PM GMT
Analysis Services database and OLAP systems: building and tuning for the best possible performance
When it comes to performance tuning there is no magic wand or short cut to wipe out the issue. The process is a constant learning and primary step is to ensure no issues are occuring repeatedly, which means you are not utilizing the time to reduce the issue. The goal in performance monitoring and tuning includes the understanding of design patterns of the database with underlying data models. For me OLAP is always a mystery and whenever I get into OLAP or BI based performance issue I always go through...... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: analysis, benchmarking, Best Practices, Cube, Monitoring, Performance, performance guide, performance tuning, scalable, SQL Server
1
kudos
spam Kudos Remove

SSIS restart issues, message: application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID
published 108 days, 4 hours, 31 minutes ago posted by sasa 116 days, 4 hours, 33 minutes ago
Wednesday, October 19, 2011 11:33:46 PM GMT Tuesday, October 11, 2011 11:32:30 PM GMT
SSIS restart issues, message: application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID
SQL Server Integration Services (SSIS) is an important service that is required to continue the ETL (extract transform load) tasks on your data platform. You may notice that since SQL Server 2005 version onwards the database maintenance plans will always use SSIS packages to perform the key maintenance activities. Though SSIS service is not imporant here but it is ideal to continue the key ETL activities using SSIS packages than TSQL methods. Just going back to basics running SSIS provides many capabilit... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: benchmarking, Best Practices, component services, error log, integration services, Security, SQL Server, SSIS
1
kudos
spam Kudos Remove

SQL Server BI Development practices: streamline the project deployment using tools
published 150 days, 8 hours, 12 minutes ago posted by sasa 158 days, 8 hours, 28 minutes ago
Wednesday, September 07, 2011 7:52:45 PM GMT Tuesday, August 30, 2011 7:37:13 PM GMT
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
spam Kudos Remove

SQL Server BI Performance series: managing CUBE performance issues
published 226 days, 13 hours, 47 minutes ago posted by sasa 235 days, 14 hours, 26 minutes ago
Thursday, June 23, 2011 2:18:28 PM GMT Tuesday, June 14, 2011 1:38:40 PM GMT
SQL Server BI Performance series: managing CUBE performance issues
What kind of performance issues you will need to face when you are setting/managing a Business Intelligence environment involving SQL Server technologies. I see this more as a practical question than to answer about the technology. When we talk about OLTP based applications then high-speed transactions, data concurrency, access and performance is a key factor. Also the volatile changes within data require constant maintenance to keep up the performance. But it may not be entirely related to an OLAP...(re... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: benchmarking, Best Practices, business intelligence, DBA, ebook, parallel processing, Query, SQL Server, SSAS, SSIS, SSRS
1
kudos
spam Kudos Remove

SQL Server Performance series: TEMPDB.. monitoring and troubleshooting practices #sql #sqlperf #tempdb
published 232 days, 14 hours, 12 minutes ago posted by sasa 241 days, 14 hours, 51 minutes ago
Friday, June 17, 2011 1:53:05 PM GMT Wednesday, June 08, 2011 1:13:55 PM GMT
SQL Server Performance series: TEMPDB.. monitoring and troubleshooting practices #sql #sqlperf #tempdb
The global resource for a SQL Server system is TEMPDB, because it holds all the information pertaining to temporary user objects, internal objects used by SQL engine, row versioning for data modifications and any ad hoc TSQL execution results. Since SQL Server 2005 version the importance for TEMPDB is increased and a compulsory object to monitor in any troubleshooting tasks. The server-wide and database-scope resources that includes all sessions, connections and storage on a SQL instance and any...(read ... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: benchmarking, Best Practices, counters, DBA, Monitoring, perfmon, Performance, performance monitoring, SQL Server, table, tempdb, troubleshoot
1
kudos
spam Kudos Remove

SQL Server optimization series - query recompilation gotchas
published 296 days, 18 hours, 48 minutes ago posted by sasa 304 days, 19 hours, 21 minutes ago
Thursday, April 14, 2011 9:16:56 AM GMT Wednesday, April 06, 2011 8:44:00 AM GMT
SQL Server optimization series - query recompilation gotchas
What causes the query to recompile? Is it a good sign or bad sign for performance? How frequently should I recompile the stored procedures? Does a reindex cause SP to recompile when it is executed next time? These are quick questions raised in the recent times that I have recieved via emails/forums/user groups, the real response for the above questions varies on version to version. By default the optimization of stored procedure - recompile: will occur when that SP is executed for first time and...(read ... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: benchmarking, Best Practices, Optimization, Performance, query plan, recompile, SQL Server, statiscs age, stored procedure
1
kudos
spam Kudos Remove

SQL Server Analysis Services: Multi-level hierarchy dimension design gotchas
published 306 days, 19 hours, 22 minutes ago posted by sasa 315 days, 20 hours, 7 minutes ago
Monday, April 04, 2011 8:43:36 AM GMT Saturday, March 26, 2011 7:58:07 AM GMT
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
spam Kudos Remove

SQL Server Performance series: TEMPDB - can't live it and can't get rid of it. Why not rename it as ImportantDB?
published 344 days, 21 hours, 6 minutes ago posted by sasa 353 days, 22 hours, 37 minutes ago
Friday, February 25, 2011 6:59:02 AM GMT Wednesday, February 16, 2011 5:28:05 AM GMT
SQL Server Performance series: TEMPDB - can't live it and can't get rid of it. Why not rename it as ImportantDB?
TEMPDB - as it sounds it is a temporary database in SQL Server, that has undergone number of changes from 2005 version onwards. As you may be aware that tempdb is used for various purpsoes such as storing intermediate results, sorting and keepng row versions, unless a good I/O & CPU subsystem is supporting the cause. Now and then I see many questions in Forums stating the performance is hampered and root cause was tempdb. Just back to basics that TEMPDB is similar to a user database to store...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: benchmarking, Best Practices, contention, dmvs, extent, performance monitoring, SQL Server, storage, system, tempdb, TSQL
1
kudos
spam Kudos Remove

SQL Server Perf: What is the optimal disk or data file placement configuration layout for better performance?
published 484 days, 7 hours, 52 minutes ago posted by sasa 493 days, 9 hours, 49 minutes ago
Friday, October 08, 2010 8:13:20 PM GMT Wednesday, September 29, 2010 6:16:23 PM GMT
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
spam Kudos Remove

SQL Server do not use PROFILER, use Server side trace to upload to table!
published 538 days, 11 hours, 37 minutes ago posted by sasa 547 days, 12 hours, 28 minutes ago
Sunday, August 15, 2010 4:28:29 PM GMT Friday, August 06, 2010 3:37:13 PM GMT
SQL Server do not use PROFILER, use Server side trace to upload to table!
As a followup questions from the post SQL Server Profiler: System is low on disk space on drive 'C'? here I had a feedback of how to save the server-side trace to a table? Well there is no direct path to do so, rather a roundabout method of once you have collected the trace using server-side method, open up the collect trace file in Profiler and click on File --> Save As --> Trace Table (see below): The reason it was disabled that I was already performing the Save-To-Table operation, as you...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: benchmarking, Best Practices, DBA, disk space, server side, SQL Server, table, trace, XML
1
kudos
spam Kudos Remove

SQL Server Management Data Warehouse 3 data collectors - useful facts
published 554 days, 12 hours, 47 minutes ago posted by sasa 562 days, 14 hours, 17 minutes ago
Friday, July 30, 2010 3:18:27 PM GMT Thursday, July 22, 2010 1:47:50 PM GMT
SQL Server Management Data Warehouse 3 data collectors - useful facts
Back until SQL Server 2005 days there was a high demand for third party tools and scripts to collect the data based upon the requirement, analyze and produce a report. SQL Server 2008 gets you Management Data Warehouse, a relational database that contains the data that is collected from a server using the new SQL Server 2008 data collection mechanism - BOL is your best friend to get to know more on introduction & How-To in specific to Management Data Warehouse. As it referred it only works from...(read m... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: benchmarking, data collector, management data warehouse, performance monitoring, schedule, SQL Server, sqlagent
1
kudos
spam Kudos Remove

Trace & Troubleshooting performance: take advantage of server side tracing for SQL Server Analysis Services
published 565 days, 13 hours, 33 minutes ago posted by sasa 574 days, 15 hours, 28 minutes ago
Monday, July 19, 2010 2:32:31 PM GMT Saturday, July 10, 2010 12:37:00 PM GMT
Trace & Troubleshooting performance: take advantage of server side tracing for SQL Server Analysis Services
Performance is the key aspect for Relational and Analytical databases, similarly processing bottlenecks are quite common within both systems if the configuration has not be set properly. Here are my thoughts & experience during a BI based project design & implementation using SQL Server 2008 version. Here comes next question, what is a proper configuration and how do you indicate that certain configuration is set for optimum performance? Analysis Services service in SQL Server 2008 provides...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Analysis Services, benchmarking, Best Practices, export, Performance, profiler, SQL Server, trace, xmla
1
kudos
spam Kudos Remove

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server
published 581 days, 14 hours, 44 minutes ago posted by sasa 590 days, 14 hours, 9 minutes ago
Saturday, July 03, 2010 1:21:36 PM GMT Thursday, June 24, 2010 1:56:13 PM GMT
Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server
No matter how best you adopt the indexing practices, few times you have to tweak the resources to obtain optimized performance. This is where a degree of parallelism needs to be applied for your complex/large resulted queries on your SQL Server, having a multiple CPU based server is a quite common criteria. By design SQL database engine with more than CPU detects the best degree of parallelism, that is number of processors employed to run a single statement, for each parallel plan execution. Unless...(re... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: benchmarking, best practice, DBA, latches, max worker threads, maxdop, numa, parallel execution, Performance, performance monitoring, Query, SQL Server, threads
1
kudos
spam Kudos Remove

SQL Server SSIS package performance series - resolve the low-memory conditions
published 648 days, 19 hours, 45 minutes ago posted by sasa 653 days, 20 hours, 54 minutes ago
Tuesday, April 27, 2010 8:20:33 AM GMT Thursday, April 22, 2010 7:10:49 AM GMT
SQL Server SSIS package performance series - resolve the low-memory conditions
SSIS Packages are integral part of database management activities, that all ETL based activities can be managed efficiently. The primary usage for these packages is to manage the movement of data from one place to another. To do that, the package needs to know where it is moving data from and where it is moving data to. Now a days the environment of source & destination server is not limited to a network or between 2 systems, it is diversified into global locations that typically enables Integration...(r... (more)
category: News | clicked: 2 | comment | | source: sqlserver-qa.net
tags: access, benchmarking, Best Practices, low memory, package, perfmon, Performance, SQL Server, SSAS, SSIS
1
kudos
spam Kudos Remove

SQL Server Manageability - Choose Analysis Services database backup strategy
published 663 days, 20 hours, 54 minutes ago posted by sasa 672 days, 23 hours, 29 minutes ago
Monday, April 12, 2010 7:11:11 AM GMT Saturday, April 03, 2010 4:35:38 AM GMT
SQL Server Manageability - Choose Analysis Services database backup strategy
Until SQL Server 2005 performing a backup of Analysis Services database was a troublesome, not like DB engine database backup statements. As said above 2005 version onwards the backup and restore operations are an integral part of the Analysis Services infrastructure, as the backup operation has been completely rebuilt. Look at the diagram that was referred in one of the Technet article that shows the interaction between Analysis Services and backup and data files: Behind the scens the operation...(read ... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Analysis Services, aso, Backup, benchmarking, Best Practices, command line, databases, holap, molap, Performance, rolap, SQL Server
1
kudos
spam Kudos Remove

SQL Server Memory Cache - take help of DMV for optimal query plans
published 702 days, 22 hours, 39 minutes ago posted by sasa 710 days, 1 hour, 15 minutes ago
Thursday, March 04, 2010 5:25:55 AM GMT Thursday, February 25, 2010 2:50:20 AM GMT
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
spam Kudos Remove

Build an Alert mechanism by using Analysis Management Objects (AMO) - implement SQL Server 2008 OLAP Best Practices
published 715 days, 23 hours, 36 minutes ago posted by sasa 722 days, 55 minutes ago
Friday, February 19, 2010 4:29:33 AM GMT Saturday, February 13, 2010 3:09:54 AM GMT
Build an Alert mechanism by using Analysis Management Objects (AMO) - implement SQL Server 2008 OLAP Best Practices
SQL Server 2008 offers Analysis Management Objects (AMO) a complete library of classes designed to manage an instance of Analysis Services from a client application in managed code under the .NET Framework version 2.0. What I believe on the usage of these AMO in Analysis Services 2008 will alert you whenever best practice is not being followed: suggestions and warnings are delivered by AMO and are identified by a curvy blue line underneath the object in question. The message is displayed when you...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: amo, Analysis Services, benchmarking, Best Practices, Books Online, management objects, Security, SQL Server
1
kudos
spam Kudos Remove

SQL Server - SSIS package transformation performance issues, follow up
published 722 days, 5 minutes ago posted by sasa 728 days, 14 hours, 50 minutes ago
Saturday, February 13, 2010 3:59:54 AM GMT Saturday, February 06, 2010 1:15:07 PM GMT
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
spam Kudos Remove

No politRics here, comparison of a RDBMS product for best benchmarks and delivers trusted results?
published 860 days, 14 hours, 13 minutes ago posted by sasa 863 days, 22 hours, 48 minutes ago
Sunday, September 27, 2009 1:52:35 PM GMT Thursday, September 24, 2009 5:16:49 AM GMT
No politRics here, comparison of a RDBMS product for best benchmarks and delivers trusted results?
Introduction This is the first post of Facts and Fixtures section here, as a good start I'm beginning this blog section that I could use some 'real world' opinions here, as you can see on this site which is a standard community type site with a motto of 'Knowledge Sharing Network'; being a found of this network I believe in providing real-world facts and figures to my community and users in Cyber World. Every one has got right to share their thoughts and opinion, but at the same it is not a 'good...(read... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: benchmarking, competition, editions, features, interop, marketing, mysql, RDBMS, results, SQL Server