Browse by Tags

All Tags » performance (RSS)
SQLKnowHow - gear up for exclusive training from professionals
Published 8 July 8 8:27 AM | SSQA.net
SQLKnowHow is the new organisation that is focused on training services based on SQL Server. In this regard they have lined up very interesting list of events in coming months, it will be a great time for the SQL Server Users in United Kingdom to grab...
Filed under: , , , , , , , ,
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: , , ,
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 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 - Precision Performance techniques using RML Utilities
Published 9 June 8 7:50 AM | SSQA.net
As a DBA, you probably often find yourself striving or struggling to improve the performance of SQL Server instance queries (might be smaller or complex ones). By default in order to get further analysis on the system's performance you need to perform...
Filed under: , , , , , , , , ,
SQL Server 2005 DMV - quick information to find resource allocation & DDL bottleneck
Published 9 June 8 3:29 AM | SSQA.net
Initially I preferred to put this blog post within Performance tuning blog section here, but as it relates to the TSQL script thought this is best place to go. Anyways, if you have a performance problem the foremost option is to find whether the server...
Filed under: , , , , , ,
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 High Number of User Connections found on PERFMON, how to resolve it?
Published 3 June 8 3:7 AM | SSQA.net
I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as...
Filed under: , , , , , , , , ,
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: , , ,
SQL Server Performance issues with Fragmentation and heavy usage of TEMPDB?
Published 15 May 8 3:59 AM | SSQA.net
Whenever a performance issue occurs on the SQL Server database best option for diagnosing and troubleshooting common problems by using publicly available tools such as Profiler, System Monitor (Perfmon), and Dynamic Management Views (DMVs) in SQL Server...
Filed under: , , , , , , ,
How hard is it to pick the right non-clustered indexes?
Published 14 May 8 5:13 PM | SSQA.net
Kimberly and I were presenting at our local (Redmond) .Net Developers Association on Monday and the following question came up while Kimberly was talking about missing and extra indexes (paraphrasing): What's the best non-clustered index to use for...
Filed under: , ,
SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?
Published 14 May 8 3:23 AM | SSQA.net
I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant...
Filed under: , , , , , , , , ,
SQL Server Reporting Services: Resources and information - all in one place
Published 13 May 8 3:30 AM | SSQA.net
During a conference few users asked about resources and information to go through the Reporting Services, as it is a general assumption from the end-user community that referring to Books Online aka BOL doesn't get them anywhere. I always recommend...
Filed under: , , , , , , ,
A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000
Published 12 May 8 1:43 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications A query that references a nondeterministic...
Filed under: , , , , , ,
SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?
Published 8 May 8 3:42 AM | SSQA.net
When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...
Filed under: , , , , , , , , , ,
SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)
Published 2 May 8 9:12 AM | SSQA.net
Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because...
Filed under: , , , , , , ,
SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?
Published 28 April 8 3:1 AM | SSQA.net
You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based...
Filed under: , , , , , , , , , ,
64 bit computing configuration with SQL Server 2005 - what you can take-on?
Published 23 April 8 6:31 PM | SSQA.net
It has been a while in posting X64 related information here, so that comes now about configuration gotchas you may need, for a starter though. X64 computing platforms have become common installations now a days due to the hardware reduced costing and...
Filed under: , , , , , , , ,
SQL Server databases - checkpoint, cache and I/O request - what you need to know?
Published 22 April 8 1:51 PM | SSQA.net
Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...
Filed under: , , , , , , , , , , ,
SQL Server 2008 TSQL enhancements - what I like?
Published 4 April 8 9:58 AM | SSQA.net
Simple, short and crisp - I would like to say about TSQL enhancements within SQL Server 2008. You may already aware about what's new and how best you can take advantage within your code, most of the Developers would agree about IntelliSense functionality...
Filed under: , , , , , , , , ,
More Posts Next page »