nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

DPA hoa to resolve DPA indication on SQL SERVER Problem

yalla

Hi ,

I have a SqlServer 2008 r2 under DPA

in the RESOURCE TAB
DPA give me an ALERT about Procedure Cache Hit Ratio

Lookin on on online help i 've seen :

Percentage of time when SQL
Server looks for an execution plan in the procedure cache and finds it for this instance.

If this is low, try to write more reusable code and/or consider increasing the size of the
procedure cache

To see current metrics for
the procedure cache, run the query:

select * from
master..sysperfinfo where object_name like '%Plan
Cache%';

But i cant' t find how increase this value , it seems is an automatic parameter