SqlServerKudos - Stories tagged with Performance

Performance

atom rss
1
kudos
spam Kudos Remove

Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook
published 22 days, 20 hours, 54 minutes ago posted by sasa 25 days, 21 hours, 29 minutes ago
Friday, January 13, 2012 7:10:26 AM GMT Tuesday, January 10, 2012 6:34:53 AM GMT
Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook
When we talk about availability the key step in providing the feature is to ensure such feature is available and easily implemented. High Availability is purely dependant on hardware and software that will activate the failover or failback whenever the system is affected with the problem. Similarly, more complex and larger a database application, the more important it is to automate administrative tasks with proactive maintenance tasks to ensure data is available. The key factors for hardware and...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: #sql2k8r2cookbook, cookbook, database mirroring, high availability, key, Performance, solution accelerator, SQL Server
1
kudos
spam Kudos Remove

SQL Server Training in the UK–SSIS, MDX, Admin, MDS, Internals
published 69 days, 11 minutes ago posted by sasa 73 days, 1 hour, 26 minutes ago
Monday, November 28, 2011 3:52:49 AM GMT Thursday, November 24, 2011 2:38:07 AM GMT
SQL Server Training in the UK–SSIS, MDX, Admin, MDS, Internals
If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb. Why this company rather than any others? Training based on real world experience...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Performance, Query Tuning, SSAS, SSIS - Integration Services, Training
1
kudos
spam Kudos Remove

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, 55 minutes ago posted by sasa 109 days, 4 hours, 46 minutes ago
Friday, October 28, 2011 12:09:02 AM GMT Tuesday, October 18, 2011 11:18:06 PM GMT
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
spam Kudos Remove

Analysis Services database and OLAP systems: building and tuning for the best possible performance
published 101 days, 4 hours ago posted by sasa 110 days, 4 hours, 51 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

SafePeak's SQL Server performance contest - share your story get lucky to win!
published 119 days, 5 hours, 12 minutes ago posted by sasa 128 days, 6 hours, 11 minutes ago
Saturday, October 08, 2011 10:51:40 PM GMT Thursday, September 29, 2011 9:52:44 PM GMT
SafePeak's SQL Server performance contest - share your story get lucky to win!
Its always good when you can mix your learning and knowledge in innovative way. My fellow MVP and good friend Robert Pearl (@pearlknows) referred few highlights and information about SafePeak's products. First things first, here is the exciting news for lucky folks our there who can share their story related to SQL Server performance and your personal experience in dealing/solving such problems at your work place. You can submit your story here and even share the news to your networking to get few...(rea... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: DBA, developers, mvp, Performance, performance monitoring, problem, safepeak, share, SQL Server
1
kudos
spam Kudos Remove

Take the offer on SQL Server 2008 R2 Administration cookbook and SQL Server 2008 R2 Master Data Services
published 141 days, 6 hours, 56 minutes ago posted by sasa 150 days, 7 hours, 6 minutes ago
Friday, September 16, 2011 9:08:16 PM GMT Wednesday, September 07, 2011 8:57:47 PM GMT
Take the offer on SQL Server 2008 R2 Administration cookbook and SQL Server 2008 R2 Master Data Services
In continuation to the Packt Publishers September offer on Microsoft books I would like to promote two essential books to upgrade your knowledge in Microsoft SQL Server 2008 R2 technologies. Microsoft SQL Server 2008 R2 Administration Cookbook Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBook. Author: Satya Shyam K Jayanty Microsoft SQL Server 2008 R2 Master Data Services Authors: Jeremy Kashel , Tim Kent , Martyn Bullerwell Manage and...(re... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: beginners in sql serever, Best Practices, books, DBA, disaster recovery, ebook, master data services, offer, packt, Performance, performance monitoring, publisher, SQL Server
1
kudos
spam Kudos Remove

SQL Server BI Development practices: streamline the project deployment using tools
published 150 days, 8 hours, 11 minutes ago posted by sasa 158 days, 8 hours, 27 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

Must attend training day for anyone serious about SQL
published 185 days, 10 hours, 48 minutes ago posted by sasa 193 days, 10 hours, 21 minutes ago
Wednesday, August 03, 2011 5:16:06 PM GMT Tuesday, July 26, 2011 5:43:30 PM GMT
Must attend training day for anyone serious about SQL
I was in Denmark earlier this year speaking at Miracle Open World and I heard about a guy that had done a session the year before about the internals of PDF files. This year he was doing the one on MDF files. This was a must see, so I popped along. Mark...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Internals, Performance, SQLBits, Training
1
kudos
spam Kudos Remove

Data Warehousing 2.0 and SQL Server: Architecture and Vision
published 225 days, 13 hours, 41 minutes ago posted by sasa 235 days, 13 hours, 20 minutes ago
Friday, June 24, 2011 2:23:25 PM GMT Tuesday, June 14, 2011 2:43:37 PM GMT
Data Warehousing 2.0 and SQL Server: Architecture and Vision
As Data warehouses mature over time, the emphasis shifts from making data available to consumers to the production of data. Let’s look more closely at the data warehouse, beginning with an overview of its components. A data warehouse has a long life span and is rarely implemented all at once. This is due to a variety of factors including mergers and acquisition, changing business landscape, the request for new subject areas and new questions asked by the business . To know more about Parallel Data...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: data center, data warehouse, DBA, etl, parallel processing, pdw, Performance, SQL Server
1
kudos
spam Kudos Remove

SQL Azure Federations and Semantic Search by the SQL product team in London tonight (Monday)
published 227 days, 13 hours, 51 minutes ago posted by sasa 236 days, 14 hours, 26 minutes ago
Wednesday, June 22, 2011 2:13:32 PM GMT Monday, June 13, 2011 1:38:02 PM GMT
SQL Azure Federations and Semantic Search by the SQL product team in London tonight (Monday)
Don’t forget that tonight we have Michael Rys from the SQL Server Product Team presenting on the Federation support coming to SQL Azure and the Semantic search coming in SQL Server Denali. This is a must attend evening for anyone that is serious about...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Full Text, nosql, Performance, Scale, SQLSocial, XML
1
kudos
spam Kudos Remove

SQL Server Performance series: TEMPDB.. monitoring and troubleshooting practices #sql #sqlperf #tempdb
published 232 days, 14 hours, 11 minutes ago posted by sasa 241 days, 14 hours, 50 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

Microsoft SQL Server 2008 R2 Administration Cookbook - eBook and paperback Book - quick answers to common problems #sql #book
published 247 days, 15 hours, 16 minutes ago posted by sasa 255 days, 15 hours, 52 minutes ago
Thursday, June 02, 2011 12:47:41 PM GMT Wednesday, May 25, 2011 12:12:29 PM GMT
Microsoft SQL Server 2008 R2 Administration Cookbook - eBook and paperback Book - quick answers to common problems #sql #book
This is something big in my life to announce, it gives immensive pleasure and happiness to share about my first book (hard paper) and eBook release, titled : Microsoft SQL Server 2008 R2 Administration Cookbook is released and out now. share my experience and task based real-world best practices in a cookbook style. My thanks to the technical reviewers: Vinod Kumar from Microsoft India, Ravikanth Chaganti - SharePoint MVP and Venkatesan Prabu - SQL Server MVP for their efforts to shape up the book...(rea... (more)
category: News | clicked: 2 | comment | | source: sqlserver-qa.net
tags: architects, availability, beginners, best practice, Book, DBA, ebooks, experience, Monitoring, mvp, packt, Performance, Programming, real-world, Scalability, SQL Server
1
kudos
spam Kudos Remove

How to make your laptop 10 times faster
published 253 days, 15 hours, 42 minutes ago posted by sasa 262 days, 16 hours, 22 minutes ago
Friday, May 27, 2011 12:22:19 PM GMT Wednesday, May 18, 2011 11:42:05 AM GMT
How to make your laptop 10 times faster
For a while now I’ve been struggling with the performance of my laptop. Over time it starts to run slowly videos play really badly and anything that is CPU bound just takes ages. Anyone thats seen my demos recently might have seen some erratic behaviour...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: laptop, Performance, Tips and Tricks
1
kudos
spam Kudos Remove

Sharding in SQL Azure
published 262 days, 16 hours, 22 minutes ago posted by sasa 267 days, 16 hours, 43 minutes ago
Wednesday, May 18, 2011 11:41:56 AM GMT Friday, May 13, 2011 11:21:32 AM GMT
Sharding in SQL Azure
The federation (sharding) support in SQL Azure is almost upon us. This was introduced at PDC in October last year http://www.msravs.com/audiosearch_demo/default.aspx?&index=Microsoft_PDC&q=federation&qr=All If you want to read about the federation...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Azure, nosql, Performance, Scale
1
kudos
spam Kudos Remove

SQL Server performance practices: Max Worker Threads, don't touch it #sql #sqlperf
published 264 days, 16 hours, 28 minutes ago posted by sasa 269 days, 16 hours, 52 minutes ago
Monday, May 16, 2011 11:36:18 AM GMT Wednesday, May 11, 2011 11:11:36 AM GMT
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
spam Kudos Remove

Next generation Data Warehouse : Free London Event
published 266 days, 16 hours, 38 minutes ago posted by sasa 275 days, 17 hours, 18 minutes ago
Saturday, May 14, 2011 11:26:22 AM GMT Thursday, May 05, 2011 10:46:11 AM GMT
Next generation Data Warehouse : Free London Event
Are you working in Data Warehousing then this event might be for you. Together, Microsoft and HP are engineering an innovative product range that combines our leading edge software and hardware assets into optimized data-warehouse appliances. In addition...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Data Warehousing, free, Performance
1
kudos
spam Kudos Remove

SQL Server optimization series - query recompilation gotchas
published 296 days, 18 hours, 47 minutes ago posted by sasa 304 days, 19 hours, 20 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, 20 minutes ago posted by sasa 315 days, 20 hours, 6 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

The optimiser should understand that year(datecolumn) is correlated to the datecolumn
published 308 days, 19 hours, 30 minutes ago posted by sasa 317 days, 22 hours, 8 minutes ago
Saturday, April 02, 2011 8:33:42 AM GMT Thursday, March 24, 2011 5:55:50 AM GMT
The optimiser should understand that year(datecolumn) is correlated to the datecolumn
If you have a query such as select year ( OrderDate ) yr , count ( 1 ) from AdventureWorks2008 . Sales . SalesOrderHeader group by year ( OrderDate ) and you have an index on OrderDate you will find that even though the query optimiser could do a stream...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Connect, Performance, Suggestions
1
kudos
spam Kudos Remove

SQL Server Manageability series: Server editions - choose the appropriate ones.
published 314 days, 19 hours, 56 minutes ago posted by sasa 323 days, 20 hours, 39 minutes ago
Sunday, March 27, 2011 8:08:00 AM GMT Friday, March 18, 2011 7:25:21 AM GMT
SQL Server Manageability series: Server editions - choose the appropriate ones.
What is the default SQL Server edition used in your organization? As a DBA/Architect are you involved in deciding what version and edition of SQL Server to be used? As a DBA do you decide which version is suitable for the application needs? It is evident that installation requirements always vary based on the application needs, as the SQL Server editions offers unique performance, scalability and availability features that always comes with a price tag. So the SQL Server components that you install...(re... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: editions, enterprise edition, feature, Installation, partitioning, Performance, setup, SQL Server, standard, web, workgroup
Previous 1 2 3 4 5 6 Next