Browse by Tags

All Tags » performance » cache   (RSS)
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...
SQL Server 2005 PERFMON counter spikes in Transactions/sec and Buffer Cache Hit ratio, what does it say?
14 March 08 02:16 AM | SQL Master | 3 Comments   
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 can Read More...
SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
25 January 08 02:41 AM | SQL Master | 3 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, Read More...
Considering Parallel plans and forcing plans for better performance
23 October 07 06:55 AM | SQL Master | 2 Comments   
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 Read More...
List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis
05 August 07 12:32 PM | SQL Master | 5 Comments   
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 Read More...
SQL Server 2005 Query optimization issue : limit affected rows on a large volume table?
10 July 07 03:40 AM | SQL Master | 1 Comments   
If you have a huge volume of table (say millions of rows) and a requirement to limit x number or sample of rows from a query every time you execute. To limit number of rows then you would think about [ select ... from (select top 100 * from X order by Read More...
SQL Server 2005: Stored Procedure call activity statistics & execution time
21 June 07 02:56 PM | SQL Master | 1 Comments   
Is it possible to get statistics like how many times a stored procedure is called such as average execution time and how often that procedure is being called. Bascially it is possible to get provided that particular stored procedure is active and plan Read More...
Recompile all the stored procedures
27 April 07 06:42 AM | SQL Master | 0 Comments   
There has been many instances of requests from the Developers to recompile a set of Stored Procedures on one of the mission critical databases, due to the performance issues the relevant SPs have been fine tuned for optimum performance. In order to take Read More...

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication