• Blog Post: Troubleshooting : Error: 8624, Severity: 16, State: 21. Internal Query Processor Error: The query processor could not produce a query plan.

    Sometimes we see the below error in SQL Server 2008 R2 SP1 when executing a query in SQL Server Management Studio: -------------------------------------------------------------- Error: 8624, Severity: 16, State: 116. Internal Query Processor Error: The query processor could not produce a query plan....
  • Blog Post: Troubleshooting SQL server High CPU : Part 2

    In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and the steps to troubleshoot it. Possible causes that can lead to high CPU usage by SQL server:- 1.Inefficient Query Plans 2. Intra- query Parallelism 3. Excessive Cache look up time To watch...
  • Blog Post: Troubleshooting SQL server High CPU : Part 1

    In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and the steps to troubleshoot it. Possible causes that can lead to high CPU usage by SQL server:- 1.Inefficient Query Plans 2. Intra- query Parallelism 3. Excessive Cache look up time To watch...
  • Blog Post: Procedure Cache-Part II

    Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing your application and SQL server performance. Procedure Cache , main goal is to cache the query plans and allow its reuse and thus minimize the compile time and improve the performance. This blog will...
  • Blog Post: Procedure cache - Part I

    Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing your application and SQL server performance. Procedure Cache , main goal is to cache the query plans and allow its reuse and thus minimize the compile time and improve the performance. This blog will...
Page 1 of 1 (5 items)