SqlServerKudos - Stories tagged with Performance

Performance

atom rss
1
kudos
spam Kudos Remove

Cumulative update package 9 for SQL Server 2008 Service Pack 1
published 4 hours, 36 minutes ago posted by sasa 9 days, 4 hours, 2 minutes ago
Saturday, July 31, 2010 3:23:24 PM GMT Thursday, July 22, 2010 3:57:49 PM GMT
Cumulative update package 9 for SQL Server 2008 Service Pack 1
Download and test the latest instalment of cumulative Update 9 for SQL Server 2008 Service Pack 1 which consist the hotfix release related to SQL Server 2008 version and fix to the issues since the release of Service Pack 1. The build number for this CU9 package is 10.00.2789.00. and KBA970365 gets you the list of builds since SQL Server 2008 SP1 release: Build 10.00.2775 (cumulative update) - CU8 Build 10.00.2770 & Build 10.00.2769 - interim fixes Build 10.00.2766 (cumulative update) - CU7 Build...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Best Practices, ctp, cumulative update, deadlock, package, Performance, release, SQL Server, Testing, trace flag
1
kudos
spam Kudos Remove

Trace & Troubleshooting performance: take advantage of server side tracing for SQL Server Analysis Services
published 12 days, 5 hours, 27 minutes ago posted by sasa 21 days, 7 hours, 23 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 28 days, 6 hours, 38 minutes ago posted by sasa 37 days, 6 hours, 3 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 HA: Quick view of Database Mirroring session between partners
published 36 days, 7 hours, 13 minutes ago posted by sasa 44 days, 8 hours, 18 minutes ago
Friday, June 25, 2010 12:46:09 PM GMT Thursday, June 17, 2010 11:41:44 AM GMT
SQL Server HA: Quick view of Database Mirroring session between partners
From SQL Server 2005 version onwards database mirroring has been a good resource to provide High Availablity for the systems without having special hardware requirement. While I was assisting at the SME lounge within Database Platform area in Tech-Ed North America conference, I had few interesting questions from the users asking about various methods to monitor database mirroring environment. Database Mirroring Monitor is the tool which is a first hand resource to see what is happening within the...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: database mirroring, DBA, endpoint, instances, Monitoring, Performance, SQL Server, Troubleshooting
1
kudos
spam Kudos Remove

Error: 17308, Severity: 16, State: 1. LazyWriter: Process 4 generated an access violation. SQL Server is terminating this process
published 51 days, 8 hours, 24 minutes ago posted by sasa 60 days, 10 hours, 45 minutes ago
Thursday, June 10, 2010 11:35:38 AM GMT Tuesday, June 01, 2010 9:14:44 AM GMT
Error: 17308, Severity: 16, State: 1. LazyWriter: Process 4 generated an access violation. SQL Server is terminating this process
Transparent Data Encryption (TDE) is the good feature that has been enhanced in SQL Server 2008, that will help secure the database such as designing a secure system, encrypting confidential assets, and building a firewall around the database servers. Whenever you consider the security of data platform you will think about passwords, access (physical) to the server and chances are high that a malicious party can just restore or attach the database and browse the data. So thats where the data encryption..... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: affinity mask, i/o, Performance, Security, SQL Server, tde, transparent data encryption
1
kudos
spam Kudos Remove

Optimising wildcard prefixed LIKE conditions | AdaTheDev
published 57 days, 8 hours, 50 minutes ago posted by AdaTheDevAdaTheDev 66 days, 11 hours, 45 minutes ago
Friday, June 04, 2010 11:09:34 AM GMT Wednesday, May 26, 2010 8:15:03 AM GMT
Optimising wildcard prefixed LIKE conditions | AdaTheDev
An overview on how to use indexed computed columns to optimise the performance wildcard prefixed LIKE conditions within an SQL query. (more)
category: Query | clicked: 2 | comment | | source: www.adathedev.co.uk
tags: Optimization, Performance, SQL, SQLServer
1
kudos
spam Kudos Remove

Scream if you want to go faster
published 65 days, 9 hours, 26 minutes ago posted by sasa 72 days, 11 hours, 54 minutes ago
Thursday, May 27, 2010 10:33:51 AM GMT Thursday, May 20, 2010 8:05:34 AM GMT
Scream if you want to go faster
My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlblogcasts.com
tags: PASS, Performance, Query Tuning, SQL Server 2005, SQL Server 2008, Tips and Tricks
1
kudos
spam Kudos Remove

SQL Server in Virtual platform - keep a close watch on physical server's configuration
published 82 days, 10 hours, 38 minutes ago posted by sasa 91 days, 13 hours, 14 minutes ago
Monday, May 10, 2010 9:21:09 AM GMT Saturday, May 01, 2010 6:45:10 AM GMT
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
spam Kudos Remove

SQL Server detected a logical consistency-based I/O error: Error 824, take help of trace flags and event notifications
published 89 days, 11 hours, 10 minutes ago posted by sasa 98 days, 11 hours, 44 minutes ago
Monday, May 03, 2010 8:50:02 AM GMT Saturday, April 24, 2010 8:15:43 AM GMT
SQL Server detected a logical consistency-based I/O error: Error 824, take help of trace flags and event notifications
This is a every DBA's nightmare to see if they have been alerted, yet another IO related post I would like to talk on explanation & resolution. Error 824 error indicates that a logical consistency error was detected during a read. A logical consistency error is a clear indication of actual damage and frequently indicates data corruption caused by a faulty I/O subsystem component. This is a pure indication about the hardware inconsistency within the environment with a serious I/O subsystem stability...(re... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: beginner, Best Practices, DBA, dbcc checkdb, error log, extended, Monitoring, Performance, reads, recovery, search, SQL Server, torn page
1
kudos
spam Kudos Remove

SQL Server I/O affinity and Snapshot backups - speed up the maintenance activity on your database
published 92 days, 11 hours, 24 minutes ago posted by sasa 99 days, 12 hours, 49 minutes ago
Friday, April 30, 2010 8:35:11 AM GMT Friday, April 23, 2010 7:10:46 AM GMT
SQL Server I/O affinity and Snapshot backups - speed up the maintenance activity on your database
Back in SQL Server 2000 version days (I think) SP1 onwards the affinity mask configuration option has been introduced, which refers to IO_affinity_mask_switch using SP_CONFIGURE statement. I/O affinity dedicates special, hidden schedulers to performing core buffer pool I/O and log writer activities. Just a brief background about the affinity mask (from Technet) as follows: Specify which CPUs in a multiprocessor computer are eligible to process SQL Server disk I/O operations. The IO_affinity_mask...(read ... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: Backup, Best Practices, configuration, Monitoring, Performance, SAN, snapshot, SQL Server, vdi
1
kudos
spam Kudos Remove

SQL Server SSIS package performance series - resolve the low-memory conditions
published 95 days, 11 hours, 39 minutes ago posted by sasa 100 days, 12 hours, 49 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: 1 | 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 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes
published 98 days, 11 hours, 54 minutes ago posted by sasa 102 days, 14 hours, 5 minutes ago
Saturday, April 24, 2010 8:05:42 AM GMT Tuesday, April 20, 2010 5:54:47 AM GMT
SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: You receive a "Provider Load Failure" error message or the WMIPRVSE.EXE process stops responding when you use a SQL Server 2005 WMI provider to obtain information about SQL Server 2005 services http://support.microsoft.com/kb/980142/en-US FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005 http://support.microsoft.com/kb/98... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: best practice, database mail, dbcc checkdb, enterprise edition, kba, Performance, SQL Server, SSAS, ssiss, SSRS, standard edition, x64
1
kudos
spam Kudos Remove

SQL Server Manageability - Choose Analysis Services database backup strategy
published 110 days, 12 hours, 48 minutes ago posted by sasa 119 days, 15 hours, 24 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

Improve Performance on query execution - control Parameter Sniffing
published 121 days, 13 hours, 35 minutes ago posted by sasa 130 days, 15 hours, 14 minutes ago
Thursday, April 01, 2010 6:25:00 AM GMT Tuesday, March 23, 2010 4:45:31 AM GMT
Improve Performance on query execution - control Parameter Sniffing
Going back to basics 'parameter sniffing' is a process where SQL Optimizer helps (sniffs) the execution process any current parameter values during compilation or reccompilation process. It will attain a pass-along values to the query optimizer so that the values can be used to generate a potential faster query execution plan/policy. That helps in some cases but at not all of the execution fashion, such as huge volume of rows are returned. It is nothing but SQL optimizer replaces the constants 'literal'.... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: kba, Maintenance, monitor, parallel execution, Performance, profiler, Query, SQL Server
1
kudos
spam Kudos Remove

Scottish Area SQL User Group - a preview of SQLBits session SQL Server 2008 Reporting Services
published 123 days, 13 hours, 44 minutes ago posted by sasa 132 days, 15 hours, 24 minutes ago
Tuesday, March 30, 2010 6:15:52 AM GMT Sunday, March 21, 2010 4:35:38 AM GMT
Scottish Area SQL User Group - a preview of SQLBits session SQL Server 2008 Reporting Services
Here is your chance to see a preview of "SQL Server 2008 Reporting Services Scalability and Performance" in this time schedule of Scottish Area SQL Server User Group: Register for Event LiveMeeting Attendee URL Click here to join Meeting Time Starts (UK time) at 18:00 , Finishes 21:00 Cost Free Organiser UK SQL Server User Group Address Microsoft Edinburgh, Waverley Gate, 2-4 Waterloo Place, Edinburgh, EH1 3EG Directions to Event Tags SSRS, Scalability, Performance Scottish Area SQL Server User Group...(... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Conference, Performance, Reporting Services, sassug, Scalability, SQL Server, SQLBits, usergroup
1
kudos
spam Kudos Remove

SQLBits The 6th Sets - Registration is open and lotz of goodies too!
published 125 days, 13 hours, 54 minutes ago posted by sasa 134 days, 16 hours, 39 minutes ago
Sunday, March 28, 2010 6:05:58 AM GMT Friday, March 19, 2010 3:20:47 AM GMT
SQLBits The 6th Sets - Registration is open and lotz of goodies too!
16 th April 2010 Church House Conference Centre, London Registration is Now Open We are pleased to announce SQLBits - The 6th Sets our latest, and if we may be so bold, our greatest event yet. On Friday 16 th April we will be hosting SQL Bits VI at the Church House Conference Centre in Westminster, London. This will be a free event. For SQLBits VI the theme is performance and scalability, anything and everything that you can think on that theme. If you are interested in sponsoring SQLBits please...(read ... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: Conference, Performance, registration, Scalability, SQL Azure, SQL Server
1
kudos
spam Kudos Remove

ORMs - Should DBAs just lighten up?
published 131 days, 14 hours, 19 minutes ago posted by sasa 140 days, 16 hours, 2 minutes ago
Monday, March 22, 2010 5:40:34 AM GMT Saturday, March 13, 2010 3:57:12 AM GMT
ORMs - Should DBAs just lighten up?
I did a presentation at on the entity framework and how to stop your DBA from having a heart attack. You can find my demos and slide deck here http://sqlblogcasts.com/blogs/simons/archive/2010/01/30/Entity-Framework-how-to-stop-your-DBA-having-a-heart-attack.aspx Whilst at DDD Mike Ormond interviewed me about my view on ORMs and the battel between DBAs and Devs. To see what I said go tohttp://bit.ly/bnf1By (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Entity framework, ORM, Performance
1
kudos
spam Kudos Remove

SQLBits - The 6th Sets :: theme is performance and scalability
published 148 days, 14 hours, 29 minutes ago posted by sasa 155 days, 16 hours, 3 minutes ago
Friday, March 05, 2010 5:30:51 AM GMT Friday, February 26, 2010 3:56:15 AM GMT
SQLBits - The 6th Sets :: theme is performance and scalability
In the database world Performance and Scalability goes in line like a railway track! In parallel SQLBits conferences are more popular in UK and Europe, where you get real-world content to learn and share. For the year 2010 it is SQLBits - The 6th Sets our latest, and if we may be so bold, our greatest event yet. The theme is performance and scalability, anything and everything that you can think on that theme. Once the sessions are submitted and ready for voting, registration will open around the...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Best Practices, Conference, DBA, meeting, Performance, real world example, Scalability, SQL Server, SQLBits
1
kudos
spam Kudos Remove

An evening of performance troubleshooting and Ways to learn SQL Server, with a prize draw - Scottish Area SQL Server User Group February 25 2010
published 148 days, 14 hours, 29 minutes ago posted by sasa 156 days, 14 hours, 59 minutes ago
Friday, March 05, 2010 5:30:51 AM GMT Thursday, February 25, 2010 5:00:15 AM GMT
An evening of performance troubleshooting and Ways to learn SQL Server, with a prize draw - Scottish Area SQL Server User Group February 25 2010
Here is the news for Scottish Area SQL Server user group members and new comers in Scotland that are enthusiastic to learn tips & tricks to tackle your day to day problems in SQL Server arena. Time Starts (UK time) at 18:00 , Finishes 21:00 Cost Free Organiser UK SQL Server User Group Address Microsoft Edinburgh, Waverley Gate, 2-4 Waterloo Place, Edinburgh, EH1 3EG Directions to Event Scottish Area SQL Server User Group Meeting, Edinburgh - Thursday 25th February ** Prize Draw Win £50 of Amazon...(read ... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: BOL, learning, meeting, Monitoring, Performance, query tunning, quest, sassug, SQL Server, Troubleshooting, usergroup
1
kudos
spam Kudos Remove

Getting your joins wrong can really impact performance
published 154 days, 14 hours, 58 minutes ago posted by sasa 163 days, 16 hours, 35 minutes ago
Saturday, February 27, 2010 5:01:11 AM GMT Thursday, February 18, 2010 3:24:38 AM GMT
Getting your joins wrong can really impact performance
I've just posted about filtering with joins is difficult to optimize (http://sqlblogcasts.com/blogs/simons/archive/2010/02/16/Filtering-by-joining-is-difficult-to-optimise.aspx). This post is along the same lines and is about the opposite, when joins don't filter as expected but rather they expand the result set. As with the filtering post, this join situation I am going to describe is also difficult to identify and the database tuning advisor won't be able to help you either. Someone asked me the ot... (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Performance, Query Tuning
Previous 1 2 3 Next