Hi All,
I noticed that my ASP size is growing but the database size remain constant. I suspect it is the SQL Packages that are contributing to the growth in ASP size and discovered that there is a difference between the library size and actual size of SQL Packages. E.g, R3<SID>X0000.
[http://flic.kr/p/8UtGWM] (Screen shot showing SQL package library size)
[http://flic.kr/p/8UtGXv] (Screen shot showing SQL package size capture from DBACOCKPIT)
Why is there a difference between the two sizes? Is it possible to reduce the library size of the SQL Packages so as to free up the ASP space?
What other factors could contribute to ASP growth if the database size remain constant?
Thanks in advance.
Regards,
Lim