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 an upgrade. Performance Studio builds on the concept...
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 troubleshooting databases that have used...
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 to monitor the general performance characteristics...
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 for further fine tuning for queries or tasks. Still...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
06-05-2008
Filed under: sql server, profiler, performance, tools, troubleshoot, utilities, ostress, pssdiag, readtrace, sqlnexus, versions, RML utilities
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 attach storage. The important factors such as virtualization...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-28-2008
Filed under: sql server, performance, tools, 2005, san, best practice, raid, hardware, configuration, benchmarking, downloads, iometer, deployment, sqlio
Also see Idera's hilarious new video! "Life of Simon, SQL Server DBA" http://www.youtube.com/ideradotcom View Video Format: ??? Duration: --:--...( read more )