We are running Adaptive Server Enterprise.Any suggestions?

Author Name Status Posted Time August Buell 4/17/2009 10:53:14 PM Author is Offline Hi, We are running Adaptive Server Enterprise/11.9.2.4 on a Sun box and we are running into few performance issues.we are using lot of temp tables and insert into and huge procedures and i had a look at the settings for default data cache , and it reads as below, Available space: 483.69 MB Current size : 483.69 MB Currently configured: 0.00 MB does these figures look ok ? any suggestions , please ?

Subject Author Status Date Re: We are running Adaptive Server Enterprise.Any suggestions? Chudain Soovay 4/18/2009 2:42:41 AM Hi August, That looks like output from Sybase Central. It isn't currently working on my box but if I recall correctly the 'Currently Configured' option allows you to re-size the cache from the GUI. In any rate, I think you're OK but what would help is if you ran something like: Code: 1> sp_cacheconfig 2> go Post Comments Re: Thanks for the info August Buell 4/18/2009 2:46:09 AM Hi Choodain, Thanks for the info, as you have asked , here is the output from sp_cacheconfig. 1> sp_cacheconfig 2> go Cache Name Status Type Config Value Run Value ------------------------------ --------- -------- ------------ ------------ default data cache Active Default 0.00 Mb 480.28 Mb ------------ ------------ Total 0.00 Mb 480.28 Mb ================================================== ======================== Cache: default data cache, Status: Active, Type: Default Config Size: 0.00 Mb, Run Size: 480.28 Mb Config Replacement: strict LRU, Run Replacement: strict LRU IO Size Wash Size Config Size Run Size APF Percent -------- --------- ------------ ------------ ----------- 2 Kb 61440 Kb 0.00 Mb 480.28 Mb 10 (return status = 0) thinks are in control now , but occassinally the db slows down, so am in the process of taking preventive steps. any suggestions with in the info above ? Post Comments Re: We are running Adaptive Server Enterprise.Any suggestions? Issac Manicfan 4/18/2009 2:44:09 AM You prob. also want to run sp_sysmon. It's really hard to say if that is enough cache w/o k nowing how big the databases are, how much memory you have on the box etc. Post Comments Re: Thanks for the suggestion August Buell 4/18/2009 2:47:44 AM Hi Issac, Thanks for the suggestion. sure i will post soon with the output from sp_sysmon Post Comments Re: You will get a ton of info Issac Manicfan 4/18/2009 2:48:43 AM You will get a ton of info from sp_sysmon. Check the results for cpu utilization, cache utilization and IO rates. Post Comments

Related Forums Get a Website Template for Free!!! Get a Website Template for Free!!! Free Script for PHP Web Directory Looking for a Blogging Software Flash Website Tutorials