Other SQL Server Blogs around the Web

Browse by Tags

• backup
• backups
• baseline
• best practice
• best practices
• blogs
• buffer
• busy
• calculate
• capacity
• certificate
• checkpointl
• configuration
• cpu
• create
• creation
• database
• databases
• dba
• dbcc shrinkfile
• disk space
• dmv
• execution
• flush
• force
• guide
• hardware
• huge
• i/o
• index
• indexes
• memory
• monitoring
• msdn
• online
• operating system
• optimization
• parallel execution
• partition
• perfmon
• performance
• queue
• raid
• ratio
• registry
• runnable
• security
• sp_who
• sql server
• sysmon
• system
• table
• temp tables
• tempdb
• transaction log
• troubleshoot
• tsql
• users
• workfiles
• worktables

• SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?

  In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases... Posted Apr 25 2008, 03:30 AM by SSQA.net Filed under: sql server, cpu, cache, memory, indexes, databases, monitoring, operating system, huge, dbcc shrinkfile

• SQL Server databases - checkpoint, cache and I/O request - what you need to know?

  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... Posted Apr 22 2008, 01:51 PM by SSQA.net Filed under: i/o, sql server, cache, performance, database, backup, msdn, transaction log, monitoring, blogs, checkpointl, flush

• SQL Server Memory - what's your method on Configuration and Troubleshooting Issues

  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... Posted Apr 01 2008, 04:49 AM by SSQA.net Filed under: memory, raid, hardware, system, monitoring, best practice, troubleshoot, configuration, baseline, sql server, cache, performance, disk space

• SQL Server 2005 PERFMON counter spikes in Transactions/sec and Buffer Cache Hit ratio, what does it say?

  Recently I was involved in one of the Performance Audit exercise at a client's place where they complain about Server CPU is always HIGH and what they have observed is even the physical disk where TEMPDB is located has been used extensively, as they... Posted Mar 14 2008, 04:16 AM by SSQA.net Filed under: dmv, sql server, cache, performance, tempdb, monitoring, sysmon, perfmon, temp tables, buffer, workfiles, worktables, ratio

• TSQL to get current executing statements - SQL Server 2005

  Using SP_WHO or SP_WHO2 is a common way to get list of executing processes currently on the server, within SQL Server 2005 you could take advantage of DMV that lists currently-executing statements. select r.session_id ,status ,substring(qt.text,r.statement_start_offset... Posted Feb 12 2008, 02:27 PM by SSQA.net Filed under: dmv, sql server, cpu, cache, tsql, queue, execution, sp_who, runnable

• SQL Server 2005 TSQL to obtain buffers by object (table, index) in the buffer cache?

  As a programmer interacting with SQL Server's cache is not often needed, but when you do need to determine what is going on with the cache, or you simply need to flush the execution plans or data pages to tune a query, you now have the means to do... Posted Feb 01 2008, 06:30 AM by SSQA.net Filed under: dmv, sql server, cache, table, tsql, memory, indexes, configuration, buffer

• SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!

  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... Posted Jan 25 2008, 03:41 AM by SSQA.net Filed under: sql server, cache, performance, tsql, online, indexes, users, monitoring, best practice, backups, create, operating system, creation, busy

• Considering Parallel plans and forcing plans for better performance

  Parameterizing T-SQL queries are a well-known task such as database programming and best practice in some tasks. It allows query plan reuse and eliminates the need of recompilation for multiple invocations of the same query that simply has different parameter... Posted Oct 23 2007, 08:55 AM by SSQA.net Filed under: sql server, cpu, cache, performance, optimization, index, partition, parallel execution, force, guide

• Calculate size of an index for a new database?

  How can you calculate size of an index in a database whenever a capacity planning exercise if performed? By default the size allocated for each user objects depends on the user application and on the amount of space that is created by the application... Posted Oct 17 2007, 02:06 PM by SSQA.net Filed under: sql server, cache, database, dba, indexes, tempdb, best practices, calculate, capacity

• How to configure SQL servers to use certificates?

  Continuation to the BlogPost on issuing or configuring SQL Servers to use certificates, I have found useful reference on Technet blogs - Mr. Cert’s side of the story ....( read more ) Posted Sep 03 2007, 06:50 AM by SSQA.net Filed under: sql server, cache, security, certificate, registry

• List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis

  Dynamic Management Views (DMV) are very useful to get server state information to monitor the status, but not always you have to still continue in monitoring using SYSMON & PROFILER that are available by default with SQL installation. The engine within... Posted Aug 05 2007, 02:32 PM by SSQA.net Filed under: dmv, i/o, sql server, cpu, cache, performance