I was recently remembered of a time I was working more with performance tuning on Oracle. The following is something that I had discovered to be very similar between Oracle and Microsoft SQL Server, but the names are different between the two systems. So this brings me back to the question of how much procedure cache memory does one SQL …

How much Procedure Cache memory does one SQL Statement take up? Read more »

Being day 12 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC FREEPROCCACHE. Description: DBCC FREEPROCCACHE is used for purge all of the parsed query plans out of memory. This is commonly used in development environments, but not as common in a production environment. Use in a development environment is common, for instance when you are …

DBCC FreeProcCache Read more »

I recently have had the opportunity to work on performance tuning on Microsoft SQL Server 2005. Recently I have been doing more with performance tuning on Oracle. The following is something that I have discovered to be very similar between Oracle and Microsoft SQL Server, but the names are different between the two systems. So this brings me back to …

How much Procedure Cache memory does one SQL Statement take up? Read more »