Browse by Tags

All Tags » sql server » 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: , , , , , , , , ,
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: , , , , , , ,
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: , , , , , , , , ,
SQL Server configuration disk layout - best practices from field
Published 3 April 8 3:17 AM | SSQA.net
Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version). Not only this...
Filed under: , , , , , , , , ,
SQL Server Memory - what's your method on Configuration and Troubleshooting Issues
Published 1 April 8 4:49 AM | SSQA.net
Memory - an important aspect of system performance within a RDBMS platform, not specific to a database product or application. Coming to Microsoft related products such as Windows Server and SQL Server so on, various resources available on web such as...
Filed under: , , , , , , , , , , , ,
More Posts Next page »