Browse by Tags

• baseline
• best practice
• cache
• configuration
• databases
• dbcc
• disk space
• dmv
• error
• fragmentation
• hardware
• identify
• indexes
• kba
• memory
• monitoring
• performance
• profiler
• query
• raid
• script
• sql server
• sqldiag
• sqldumper
• stats
• storage
• system
• table
• tuning
• usage

SQL Server Memory - what's your method on Configuration and Troubleshooting Issues
01 April 08 02:49 AM | SQL Master | 5 Comments   

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 Read More...

Filed under: performance, sql server, cache, memory, troubleshoot, raid, hardware, best practice, disk space, monitoring, system, baseline, configuration

Make use of tools and utilities that are available in SQL Server - performance & tuning
08 July 07 05:19 AM | SQL Master | 1 Comments   

There are various tools available within SQL Server installation such as SQLDIag, SQLDumper, PSSDiag (to be downloaded as a seperate tool), SYSMON(PERFMON) and Profiler etc. Among these SqlDiag and Sqldumper are most important to get more information Read More...

Filed under: tuning, performance, query, error, troubleshoot, script, kba, sqldiag, sqldumper

Handling and troubleshooting memory issues in a SQL Server 2005 instance
19 June 07 02:29 AM | SQL Master | 2 Comments   

We had a major issue on one of the SQL Server instance with the memory and getting following error message intermittenlty: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. Eventually I was able Read More...

Filed under: troubleshoot, usage, performance, sql server, dmv, memory

How to detect a table fragmentation?
29 May 07 06:02 PM | SQL Master | 2 Comments   

In SQL 2000 version days you could take help of DBCC SHOWCONTIG statement, but this is deprecated in SQL Server 2005, so how to go about it. You can take help DMVs & DMFs in this case, DMV - Dynamic Management View and DMF - Dynamic Management Function, Read More...

Filed under: performance, troubleshoot, table, dbcc, fragmentation

Identify and troubleshoot slow running queries in SQL Server
25 May 07 04:53 AM | SQL Master | 4 Comments   

Achieving the performance for slow running queries is not a rocket science to understand. The database performance is dependant on implementing optimum database design with sensible hardware-based configuration and capacity planning. So how you can identify Read More...

Filed under: performance, stats, indexes, profiler, databases, storage, identify, troubleshoot