Browse by Tags

• baseline
• best practice
• compiled
• configuration
• cpu
• databases
• dbcc shrinkfile
• disk space
• hardware
• huge
• indexes
• integration
• management
• monitoring
• operating system
• package
• performance
• plan
• raid
• security
• sql server
• stored procedure
• system
• times
• troubleshoot

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
25 April 08 01:30 AM | SQL Master | 2 Comments   

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

Filed under: sql server, cache, memory, indexes, databases, cpu, monitoring, operating system, huge, dbcc shrinkfile

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

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

Filed under: stored procedure, times, compiled, performance, cache, memory

What events will cause a flushing of plan in cache?
14 May 07 05:17 AM | SQL Master | 3 Comments   

We already know that using DBCC FREEPROCCACHE will have the affect of flushing all the cache with immediate affect and also DBCC FREESYSTEMCACHE (new in SQL 2005) has similar affect but will flush the plans asynchronously that are marked as unused anymore. Read More...

Filed under: sql server, security, management, plan, cache, memory, perfmance

Reset cached plan - how to and what to?
14 May 07 01:53 AM | SQL Master | 1 Comments   

I don't believe you would need to reset the cache on a production server, it is not a best practice to perform in this case. Most of the times in development or test environments for the purpose of benchmarking you would need to reset the cache for optimum Read More...

Filed under: sql server, plan, integration, package, cache, memory, indexes, perfmance