Browse by Tags

SQL Server 2008 - Performance Studio

Published 20 June 8 11:50 AM | SSQA.net

I've been looking at this new feature of SQL Server 2008 in order to demo it to customers, and I have to say it's pretty cool ! Along with Resource Governor and compression, it's one of my favourite new features and a good reason to consider...

Filed under: sql server, performance, tools, 2008

Indexing Strategies

Published 17 June 8 2:2 AM | SSQA.net

I attended a SQL Server User Group meeting earlier this year and heard a presentation about favourite DMV's. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have been involved in performance...

Filed under: sql server, performance, tools

SQL Server 2005 Performance Dashboard

Published 12 June 8 6:25 AM | SSQA.net

I've had one or two requests recently to set up the Performance Dashboard reports on SQL Server so I've created this blog post to step through the process. Firstly, the Performance Dashboard was created to allow customers and support engineers...

Filed under: sql server, performance, tools, 2005

SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose?

Published 5 June 8 2:50 AM | SSQA.net

Not alone with SQL Server you would be able to identify the root cause of a performance issue or to monitor any kind of activity. As you may be aware SYSMON (PERFMON) and PROFILER will help to some extent of finding offending processes on the SQL Server...

Filed under: sql server, profiler, performance, tools, troubleshoot, utilities, ostress, pssdiag, readtrace, sqlnexus, versions, RML utilities

Did You Know? Free SQL Server Troubleshooting Tools

Published 17 May 8 10:47 PM | SSQA.net

I'm very excited about the new Management Data Warehouse coming in SQL Server 2008 (which was called Performance Studio at one point), but keep in mind there are lots of available tools in the current versions. One of the students in my class last...

Filed under: performance, tools, troubleshooting, Management Tools

Best way to deploy SQL Server 2005 with SAN

Published 28 January 8 2:1 AM | SSQA.net

If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct...

Filed under: sql server, performance, tools, 2005, san, best practice, raid, hardware, configuration, benchmarking, downloads, iometer, deployment, sqlio

Whitepaper on Predeployment I/O Best Practices, plus a few urban legends around SQL Server IO

Published 10 January 8 4:38 PM | SSQA.net

There's a new whitepaper on TechNet that I've just come across (even though it was published 6 months ago!) called Predeployment I/O Best Practices . It's really good - discussing the following: Guidelines for determining I/O capacity Disk...

Filed under: performance, tools, IO Subsystems

Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?

Published 12 December 7 12:7 PM | SSQA.net

While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL Server 2008. We touch on a ton of different features (look at the number of Categories I've tagged this with!) and...

Filed under: performance, tools, replication, disaster recovery, dmf, database mirroring, encryption, compression, SQL Server 2008, Indexes From Every Angle, Database Maintenance, Interviews, Page Checksums, Backup/Restore, Conferences

Life of Simon, SQL Server DBA - hilarious video

Published 17 August 7 2:43 AM | SSQA.net

Also see Idera's hilarious new video! "Life of Simon, SQL Server DBA" http://www.youtube.com/ideradotcom View Video Format: ??? Duration: --:--...( read more ) Read More...

Filed under: sql server, performance, management, tools, video, idera, third party