首页 技术 正文
技术 2022年11月19日
0 收藏 908 点赞 2,848 浏览 9892 个字

<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfIAAACbCAIAAAAWf46hAAATTUlEQVR4nO2dT/BlR1XH3wzDMEZBwhCiEWT4oyEhwUQrOFMKlgusEahCjCQhEAYwwoQEQgKOICIEgwHKcimFsqF0wQIWVty40HrudOfChW5Qa6IxTAJhNDDRxXPRv9/99es+5/Tp++/de+fzqVNT/fqde87pvre/03PffW9W//SPf//kE/+8+o3zY9g7zh/S7Lbzh247f/i284dveyy12x87fPtjzxHtjj07cmD/sWfv3LPn5nbngR1N7F3/2djzEnv3lh2L7a7GHj921+M/FNt7UruisTOJ/dcPN/ZewX4k2Ptke/77nnj++2V7wfufeMFvqvajdwf7dm4v/C3dPvDtK7fswoF98MKLNDt74UVnLxwX7Mnj9zx5/J4nX5zbhw7sqsTuDfbUVfc+9ZLE7tuyq2P78Jb92Ie/c2AfSe3HG7tfsGvu/84193/3mo8K9hPBHpDtpQ9896UPBns6sZc9+PTLPqbaT348se819vLf1u3c904IdvHEuYsnfufiKzT7xMVXfOLiK0X75MVXfvK/XyXa7+7Zq3P71IH91Kf+Z8t+78B+OrFPb9m1e/bMtZ9+5trf37LXxPaZ1K4L9tlnrvvs9xO7PthDsr32oe+/9nOx/aCxGz73gxv+QLUbHxbt0o0PX3rd53X7w0s/o9kjl2565FnZvvDsTV949uZ9WyHryDqyjqwj68g6so6sI+vIOrKOrCPryDqyjqwj68g6so6sI+vIOrLeh6zf+u+Hbv3WoVv/tWTfWt36b8g6so6sI+vI+tRl/dibv3792b++8Z6/veHs3+R2833rm+5d/+xH/u719zz6wrd+7dBb/wFZR9aRdWQdWZ+0rF/5sX+5+o+evvpLT+X2ki8+9a5H//dt3/y/M49e+pM//vNT7/7a6vVfQtaRdWQdWUfWJy3rv/TgX9x850d/7q5zop06c+7kmXOnzpz75ffcd/2vPXzkls9oOr7Zxpb14JNo+kbhObcLbx25Q/VPSGS96W80XTswaHrSGTR9vz0DWY+Lj2V9u39PwcPLHmW9STFHWQ+Vd5H1eJJby7p2fQ4t63lGZH02sv4Lb/7gyseLr3v7sVOfNzR9q10v66Kyx7v10BPv1hu3I+/ca4dNetPea+zLenh50NCVPdb0sE/fa48l6yFFR1kPQeJ2kPX99oG+DyTrx/eVfY6y3tduPcxAl916iBC26qE9zm495Aq79dBG1uch6yd/9exqtTp9+nQ4badPn250fLPZxLJ+/DVvP3ZSkPVwYO1NmHDU0LL+3DsPlD00jm5v2/2yntyECW9NXNZzibdlXVZ2ZB1ZR9bnJeu3/MrdQcFPnz4dxL0R9ETl28l6I5SDynpDv7IuKHtJ1pM4V2Q9DUHW0873pj2bbXGP+4OU5/7afRjx3np4qyjrSYorP3BhkxHLevJWUdZj5yDrefzNZtPIetzZu6zHwRNZT+ppZD3pH03Wk7yNrMedyPrlK+v5XZdG5YeQ9cOSsufLeOeyHt9eTz4yDZ2xrO/1RPoedut77TOPX3Fmrx1retihx21ttx46w259r+1T9mS3nmh68pFp6IxlPfRcGel72K3neWNN9+/Wg0/Yp4f2VZGyHzT2d+vhZazvhqznRW42m3b31kNP2KQ37UbT4/vpLWRdrNOWdaEdafqJrbYq62Je8fY699ZnI+vhJsxG2q0nG/Z+b8LMSNbze+uarMe79eQmTBw8vgnTdHpuwuR1dpH1/Z70SZjQr8l6fBMmz9tF1mOa2y8HPdFNmNx/tI9Mm4zxTZjQ01HWO+7W85sw8fx0363zJMz8ZF28t55s2EeQ9cPbD70kDziGzlzWmxvrm7ay/rxtZRcfcAxvFWU936rbsp5v1Z279dg2GUVZ338pPOAY3hpf1sV7603kXNZ3+CRMeGsKsp5u27c13bNbR9YXK+seNFm3n4RplqX43Hp4azhZ32uUnoTRZD281GQ9VXb9Jkx8+yX+yDT0DHcTJm/nH5mKz60Hh95vwjRuY96E6VHWQ89AN2FayLrQrr8Jg6wvUNZ/8S0fcsr6Vdf9+rFTD3ueW3feW/fL+iYjeW79SCblDcXn1ouy3pB/HSn0J7LekDwJs9eZyXpD8tx601/7kWnAeG49d7ZlPfnIVNP0gPiR6WazMWR9yh+ZBmJZP+iMnoRJ3sqfWw+0/jpSHET9vDTbrcd0eW4dWZ+ZrL/ubY+cuOUdrzp5p22vPnnHy9/48aM//5Am6y1uwsT30+f7LdNQf/EBx+A2o2+ZhoL5lmntA46xrPMtU2R9N7J++E1/efSNf3r0DV8t2Z8dfcOXD7/pr3qX9cX/eEC865mRrPPjAS1kPd+wI+vI+i5+wXEgQ9an8eMByPrOv46ErCPryDqyjqwj68g6so6sI+vIOrKOrCPryDqyjqwj68g6so6sI+vIOrKOrCPryDqyjqwj68j6cLKOYRiGLcP2ZP0bX/8KhmEYtgA7kPUH7r8bwzAMm7ttybrzd2AAAut9bJ+RqgGAALIOBo0oxw2PmucRAGAkkHUwEGW9XQQAGAlkHQyqZH1dw9CVA1y+xLKerLd8+U1qQXYXiN7HO7Jmxbnydq2Giv4dFbndhLTOWOWpBRf7tXqMOtvNGEAP5LIerkLjSt1FmSlJnclbtUHEl2JPbcxBiXMZY3GWpGmc6GbImRizak7azaH/KOe8aZ3atec5FmAMRFn3rNjdotVWVbNnWfZV2BA45clZkqZKtpsReR0JetWc1M5h7eWqTY7noooTaf3asQAj4ZR1beWI/dqlXxun2J+MRSteQ6zNMy67zuJ4a/MWh2DPjzNacUq14o2AsYNzRP6Cez9Ki9D0J7Oh9XevCqAT4r315KptyJe0sdqTK97wb9cWF1LVKuprvF3aq2yuagciehpTVBtHbMR/atGShu2fV1JV/Kry1IuHaHnjE7SSzld++rpUBdCVLh+ZGpdsvDbyhjNUrb9dkuGsLUsjaS/t4rQ4h1Cs3B8q7xQb8Z9iKK3dS1UdPTV/+3zFZy1u5P1dqgLogUFl3ej0rAHDX0vdem13qad1W0vtHEWL+XFGizuLDfGQtUTc36Wqjp6as32+xNNnnIIWVQH0Q1+y7pEVe9n421r8VbbklEF7/Z3j7VK/098u3i7ViTYDccNOYUcweoxKtCzFk2X4D3HutAJanAiArjhlfZ2R9ycHGle5sVY9/Ub8lb7sRewlmiTKBy4mLc6PM6+/eGdST7S8nrihvbTD+muwi0neEp21qXb6F4PYoZxDABgWvmUKBobE5+1iBAAYA2QdNIqavnL82whZBxgbZB38iBqNcANMi0nJurb1ayEcrW93IlIAMG9GlvX83/L9Sq2t5lUVAgDMkinIuv+olfQYQ/ETPPsvDCfFIgEAJsGUZV2T13wzLrbtTrs8AIC5osm6cSsj3zv707XbCPt1XIzsrLC7pucRtGEak1k7M8X4Ropi/UZS7aXYs0P8k+mMM52hAciIsm4v1OKqNhClxJYzsUcLKL5VTKH5VC1g/6R52rUZPSdI66/NHk+OOFG1AxkObeyryr/Fu5wmgLHJZb24Srss49wtDy46aD7GWo3XoRE/r8F21g63p6W27c/raa8zacv7q05ijr/sMTHOrL/mxHnK4wVYrTJZFy9Zz3XsvNZzIcjXjBZZdFtnSmr7iPHFfq1TI58BbZjxDBhTUYUYJ5ltrb82+1oif0s7JO/Ms1fFKfYX6/eM13jLOa6ks5gXoCXjy7rYiP/M/fN3Df98peUHivWIFEeUpPbUsyrJgd2fJxL9V9Es5Q3jKP9IxTh2ZKPUvM5e2p4Zc47X6PeMyz4EoDdmJOv+fqPT07Y7NYwZcK55Z7Si5zpCTJf0d8yoFeCJbNTpD1Xrb5fkdy7mtYdTVQNABbu6t240DGfxXbszL9UuzOOsRTCCaxPYUXdEt1hTYh+tvyqj50B/ZKN+p4Pt33F67Zgd81bVAFDBrp6EaRaGJ462Qjyd+UC0FCKisxHB069NZu2adx7bvLRPnH+8xQMNB0/S2vmpjb/S50RDTNElr3aI8xQAWIz/3Hrc0F5qRyU9Wn/xQE8Kwzl3S8jfMg7x9LfO6+k34hh5xZdaqGIxxtBa99sjcg62RQrnuLQhOOsBUNnVt0zjtthpHCUuIfFwcV21KwygOwg3jMGYsu6RTm0js9KXhF/TtU5nGQBdMHbxAH2y2x/mdSpvi2XglO9+kwIA7J5J/d46AAB0BVkHAFgUyDoAwKJA1gEAFgWyDgCwKJB1AIBFgawDACwKZB0AYFEg6wAAiwJZBwBYFMg6AMCiQNYBABYFsg4AsCiQdQCARYGsAwAsCmQdAGBRIOsAAIsCWQcAWBTIOgDAokDWAQAWRS7r3f9/9PU2fZW6PPxTNM587uR8GUlrh1xb/3yvT7vy7uPq5XqLDx9zqtcZ4+SdEIms154Je0E6g+yW3ZbnnOQWy8M4NV2KaUdRuIsXkjPLcLLe18z0GKeXSWuXovbwkXVgh6knQSzryfjFl8kEaVM2l2ndeW0DybrnvIyJmNczrp2foH7L6Hc4Q08Osj5XDFlPEGV9Vbli1xFi8LXy94oWRDzE6DT6i3EMqvLab2nBW+dd9z1vq+2LQUtRHEV+oJ16iPo9/Vre+GWLevz+4uwV561qvGIKLamTfK5a19lj6ssCv6wb2BeEeN300k7C1sYRK7f9i3QZVzGsZ5LtsHY6I0gv4+or/jo73VXxW/gX53O9jz9FVV4tvhiz4zzb1WoFJHTJ60yt5c3fKg5hafQi6yvfldTl1GoB8/jaOS7WaQynSFVez9iNLFrS7uMygnScTyNmi3lbb5/32vqNamvnLa7cGJodpzif2ng7jqvF/FRRHJd2SD5vXVJfjnS8tx6jnUXxuixeUs6AWnxPHOMQz7v+Op3tLvGdlVeNt3X9ziyt5yo/vKr+Yp3FyHa/kbcX/3ZV2cGr5sdJbfyif7vUlyP+J2HW+xjRGoe8MUS7Y67aY4uj7tjuK742LqPfDqK91VA7Lv+xYlsbgr/+duO1D2kdx+Of43+rdp49KTzU5i3W0y715Ujvz62vM7R3q/pXvqUlxrEvl6p6iqPW6hRLEodjx/fXWdW/zrDrTw701GOX4Zkf0add/aK/XX/e73Q2hmaHKsZfZdSOS3Q24tTiySv2G2NsnfQygm+ZQi25XuyyGugDzuOiQNahBWyIlgRnc2kg6wAAiwJZBwBYFMg6AMCiQNYBABYFsg4AsChEWc8/EJ/1p+RT+5R/avUAwKLQvo6Ue85aiaZW/NTqAYDlkP8mjKE48xWjqVU+tXoAYDn4d+ued3OfxF/7m6PqCxFiTH/8LvXYQWrHm/sDAHSlVtZrHbq0nQWIEqn5ePw99dg1OOvJ3QAAurKT3broH+OMn8iiEadKtYtxjP68HnsIthsAQDVVsu4UIKdu1obN/fuSUWc9RhDPMP31AAC0Z4gnYTTNqm17UjjjiG/1WGdR1j31AAD0gPYkjEe2DOIIuYTl0bR+O35emF289pa/HnFcRvFGPWtkHQCGgG+ZAgAsCmQdAGBRIOsAAIsCWQcAWBTIOgDAokDWAQAWBbIOALAoElm3n9feSYUAAFBB/nWk0I+yAwDMEr+sa50AADAhtHvrmoI7lV38kv2q/kcCAACgDu3/MjVktyjK2q6fH0IBABicMX9vHVkHABgc8UkYzbnqDoy/DQAAvTHQkzDrbfIIyDoAwCAM9Hvr2oFicAAA6I0hvmXKrhwAYGcM9OMB7MoBAHYDvwkDALAokHUAgEWBrAMALApkHQBgUSDrAACLQvtNmMRtAc+0GE/mTGd003w2dKYPNY1Wdvcs0zzvMFf8vwkz66utKV4cxXSGNtnlPali/CDrcDmifctUdJ7vBTeXyie7vCdVjJ+5lD3Z8w6zZIhfcFxF//6NnZMtc+s4dnzDv0X8vOw8oOhsx7eHnDfEeWuRt0u/Mfbe56Hf+keuZ53hybvOzjtAS2plvdZBvKw7xmnXNpaxs0jPuOIsVYO1KZbhyTt0u7ae2sFWTUj8Mimj93rypLV1AvTJoLt1u78YqsuSFpe3M1Hr+GtJPmKMwdrYZYh5izXnxSd17moeDJ9inUao1vXYKYx3tcnx5wVoQ5Ws116Lub9zNdoOWhAjeNWy7Ct+j0vXWUYLZ2f/mPPQpR7PIa3Pi38Ch74eACyGeBLGueyLAWtlpVZujHfX27SLXzVYG2cZfuch2rX1dBlsi3qadl/1iA7iS2ccgH4Y6PfWxSBJvyegJ45YZN42FmTRIfdfZTJRjF8crIFYZIu8rftXypSuhpmH1vWslZPl8e9ST16YXZIzL0AbRv6WqXhB58tgt9e9pgU7ZCJlAMAMGFPWpyDZTiZV6qSKAYCpw2/CAAAsCmQdAGBRIOsAAIsCWQcAWBTIOgDAokhkXXvogscwAADmQf51pNCPsgMAzBK/rGudAAAwIbR765qCO5U9vpOT/23BXw8AAEOh/V+mhuwWRVnb9Rf/NQAAAF0Z4vfWkXUAgJ0hPgmjOVfdgfG3AQCgNwZ6Ema9TR4BWQcAGISBfm9dO1AMDgAAvTHEt0zZlQMA7IyBfjyAXTkAwE74f57CrOsG7IF8AAAAAElFTkSuQmCC" alt="" />

Parameter Name                          Default              Memory Used   Config Value         Run Value                Unit                     Type
——————————   ———–         ———–      ————         ———–       ——————–   ———-
procedure cache size                    3271                1116040            512000              512000              memory pages(2k)     dynamic

一、存储缓存不够

There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure SQL Server with more procedure cache.

sp_configure “max memory”,200000 (设置为共享内存的75%)

sp_configure “procedure cache size”,90000

查看:sp_configure “max memory”、sp_configure “procedure cache size”

修改:sp_configure “max memory”,200000、sp_configure “procedure cache size”,90000

二、数据库启动不了

sybase 12.5 配置了大内存后数据库无法启动

在安装目录下面,我的是C:\sybase,会有一个你相对于实例的配置文件,xx.cfg,我就是手犯贱在90000后面还加了一个零,虚拟机的内存都没有那么多,数据库怎么可能启动

<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAATcAAAA0CAIAAABgo+h/AAADrElEQVR4nO2cS5LbMAxEdf9zeuFbOIupeBgSaALUD7HfKyxkCIKaFJtyEle2x+PxeDxeAFCVDZcCFAeXAlQHlwJUB5cCVAeXAlQHlwJUB5cCVAeXAlQHlwJUB5cCVAeXAlQHlwJUx3Dp9hcvKU6JDhMdfv9q6KGlBp4dabWZ2alnYZ18J7ZL+6LBgd4p0USJ8PvXRCusoP8oDReMpcJ0FSft0mDlskvHU967+jW8gdsy7+O0T1Ct+ELR9nw5c2LesdPj9ffmxxxscLyiXkjVeiLjGmcSRkIuffmzP5aJJkpHoL/54IVyT8y0z1Tq2MRsOK5OocS83Lx15KM3qNS8iT4LeiKPA0yiLjULDnSp18TbzsUqHAsW+kzlRXYTceDdPbgJtplxUGblNL8wP2u7Bi7NcoVLs48hYvWsS7N9tDy9lK90afxakQ+6K3Wh6INLs0T/XBqZ8eBTMUQ4/dfcFX+xRLSJevHe9gqOdemCK6YuDT7ro/R4kqAl8bdH5jcrM78NTET4/c0+urkWGe9j6nxXeq3Mtu1BRI/on52HzX8uemiij2ilk56q6cx/OSvfePsWcq0AaFgzU6K/agA4HFZaEH4hCFAdXApQHVwKUJ1flz6fBEFUDFxKENUDlxJE9cClBFE9cClBVI+vc+nPP6PfLqOm5joz0/6arUL+5tn4Npc+K63Fz9Z81GDfH+/K3x6XuvS9RXV7VZcfT4k9r5vNVH1bZh7H9egh79T5Phb1WT3euLL1kftuA9N68+Nd+dvj6ndp+5DGp77wtLyGkfrx1JoeMdgDdY5le/SY9SLjTVTkvtnApf2EXO/S6XH2abUF5p4tZj+rZ887QbSK1JvzkNLTXRIXPE5gdh726Jw+x7Pzt8enuTSS3+PS5cHuGZenbecyGi8Pjvri5YtLP8GlKfd2e3l77dkuNXVG3hXe8VF6gpmjdodlzbj0ukkfv/aYX29EfTBv3uL5rzHaj91Bqn9qvEJPULxZP9WzMK5s/rxFsn897MnfG3e+SwmCiMQN/xKDUQkiFd/4qwaC+L8ClxJE9cClBFE9+B9VAKqDSwGqg0sBqoNLAaqDSwGqc5tLf37ekCqO1++/48Xdzmh4IEWEtT/f8/LtWS/fnjX7iGN935Mm6s53aXBIx1rrwOaRa1P9i5ihMq0DzXzwOJLR15piPsSl3RY15r2kONUlx+O2wBQT3wX36Pdu3cmL14tbLI/L65Otj9x3G4hcIo5NnWbeO6X7R1SdwR+57d2gaKlXOQAAAABJRU5ErkJggg==" alt="" />

三、其他相关配置

在xx.cfg配置文件中,对下述参数进行优化.(要根据你虚拟机分配的最大内存,或者服务器的最大内存而配置,不然配置大了,数据库就会启动不了)

(另如果数据库已经打开了,可以进入isql,则在islq>下输入下述语句就可以进行优化了.)

针对2g内存(redflag中为free -m  or top),多次测试后,最终参数为(数据库可以起来,不报错)
    max memory                  procedure cache size                        default data cache    
 262144     0.5g                            50m                                                    300m

–设置数据库能够使用的最大内存数,单位为2K,下面配置为2G(1024*1024)

sp_configure ‘max memory’,1048576

–设置过程缓存,单位为2K,下面配置为200M(100*1024)

sp_configure ‘procedure cache size’,102400

–设置数据库默认的数据缓存,一般为最大内存值的60%,针对2G内存,一般配置为1.2G

sp_cacheconfig ‘default data cache’,’1200M’

–设置数据库允许的最大用户连接数,下面配置为100个

sp_configure ‘number of user connections’,100

–设置数据库最大的锁数量,下面配置为50000个

sp_configure ‘number of locks’,50000

–设置数据库允许的最大设备数量,下面配置为100个

sp_configure ‘number of devices’,100

–让数据库在启动的时候一次性收集完所有内存

sp_configure ‘allocate max shared memory’,’1′

–设置数据库最大可使用的CPU数,下面配置为3个

sp_configure ‘max online engines’,3

–设置在数据库启动时加载的CPU数,下面配置为3个

sp_configure ‘number of engines at startup’,3

相关推荐
python开发_常用的python模块及安装方法
adodb:我们领导推荐的数据库连接组件bsddb3:BerkeleyDB的连接组件Cheetah-1.0:我比较喜欢这个版本的cheeta…
日期:2022-11-24 点赞:878 阅读:9,082
Educational Codeforces Round 11 C. Hard Process 二分
C. Hard Process题目连接:http://www.codeforces.com/contest/660/problem/CDes…
日期:2022-11-24 点赞:807 阅读:5,557
下载Ubuntn 17.04 内核源代码
zengkefu@server1:/usr/src$ uname -aLinux server1 4.10.0-19-generic #21…
日期:2022-11-24 点赞:569 阅读:6,406
可用Active Desktop Calendar V7.86 注册码序列号
可用Active Desktop Calendar V7.86 注册码序列号Name: www.greendown.cn Code: &nb…
日期:2022-11-24 点赞:733 阅读:6,179
Android调用系统相机、自定义相机、处理大图片
Android调用系统相机和自定义相机实例本博文主要是介绍了android上使用相机进行拍照并显示的两种方式,并且由于涉及到要把拍到的照片显…
日期:2022-11-24 点赞:512 阅读:7,815
Struts的使用
一、Struts2的获取  Struts的官方网站为:http://struts.apache.org/  下载完Struts2的jar包,…
日期:2022-11-24 点赞:671 阅读:4,898