Browse by Tags

Performance Monitoring using SQL Server Management Studio - Power of Management Data Warehouse
16 September 08 10:36 AM | ssqa.net | with no comments

Cross post from my blog: Power_of_MDW

Filed under: sql server, performance, monitoring, mdw

SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.
28 July 08 05:54 AM | ssqa.net | with no comments

It is evident that SQL Server 2005 component handles memory differently as compared to SQL Server 2000 version. As one of the KBA refers SQL Server 2000 Enterprise Edition introduces support for the use of Microsoft Windows 2000 Address Windowing Extensions...

Filed under: sql server, performance, windows server, memory, paging out, awe, enterprise

SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)
12 June 08 04:04 AM | ssqa.net | with no comments

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, 2008, performance, data warehousing, features, scalability, relational

SQL Server multiple instances and resource utilization - best practices
15 May 08 10:48 AM | ssqa.net | with no comments

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Should you configure each of the instances to use specific portions of the available Operating System...

Filed under: sql server, resources, performance, best practices, installation, multiple, instances, consolidation, virtualization

SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?
28 April 08 04:28 PM | ssqa.net | 1 comment(s)

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: sql server, performance, best practices, database, benefits, data file, sizes, 64k, allocation

How to get rowcount efficiently within a SSIS package?
26 March 08 07:51 AM | ssqa.net | with no comments

I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components...

Filed under: sql server, performance, ssis, component, package, call, rowcount

SQL Server scrollable server cursors, use them carefully!
10 March 08 07:09 AM | ssqa.net | with no comments

One sentence, if you haven't used the Cursors sensibly then database performance will be cursed! This is for newbie users and DBAs to be aware that on general recommendation is server side cursors are better than client side one, in this you need to be...

Filed under: api, sql server, server, performance, sample, tsql, data, plan guide, result set, cursors, dba

Pre-order the Kalen Delaney SQL Server Internals Course on DVD
04 March 08 06:20 AM | ssqa.net | 2 comment(s)

Ok 2 months vanished in the year 2008, what have you done so far in terms of learning new concepts and technologies. Great news to all SQL Server users! (for me mostly) The DVD - Kalen Delaney SQL Server Internals course (part1) is almost ready and you...

Filed under: sql server, course, performance, learning, training, video, new, multipart, dvd, kalen delaney

SQL Server 2008 - Declarative Management Framework (DMF) concepts - SQLBits presentation
03 March 08 06:57 AM | ssqa.net | 1 comment(s)

01st March 2008, Saturday @ Aston Lakeside Conference center, Birmingham - UK. It was a good turnout to my session this morning at 09:30 on the topic : SQL Server 2008 – Declarative Management Framework concepts & database problem solutions with policy...

Filed under: sql server, performance, database, conference, problems, framework, sqlbits, dmf, agenda, concepts

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
25 February 08 07:53 AM | ssqa.net | with no comments

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...

Filed under: sql server, 2005, server, performance, best practices, index, clustered, online, production

SQL Server 2005 Index Optimization Best Practices
19 February 08 07:04 AM | ssqa.net | 3 comment(s)

Do you have a maintenance window to perform database reindexing? Have you ever performed full set of re-organize and re-index process on a bigger database? Do you know there are best practices to deploy in this regard? On large database systems, with...

Filed under: sql server, ssqa, 2005, performance, best practices, reorganize, optimization, database, statistics, blogs, index, dbreindex, reindex

SQL Server X64 and X86 - differences and what you see in terms of performance?
13 February 08 09:15 AM | ssqa.net | with no comments

Is 64 bit means more memory? Yes, to be precise. Going forward you will see majority of Microsoft product will go with 64-bit, such as Operating System, Web & Database Application software. So what is the difference between X64 and X86 based applications...

Filed under: sql server, 64bit, x64, advantages, microsoft, x86, server, resources, hardware, 32bit, performance