Article View: microsoft.public.cn.sqlserver
Article #21Re: SQLCPU���ڴ�ռ������
From: ����99
Date: Wed, 29 Mar 2006 15:06
Date: Wed, 29 Mar 2006 15:06
23 lines
3395 bytes
3395 bytes
�ڴ�ռ��.......�����û�����κ��Ż���ʩ�Ļ���1G����ݿ����1.5G�ڴ��ǻ�����ģ� �����������ݱ��Ż��Ļ���˵������Ż��Dz��ɹ��ģ������Ч�������ݽṹ�� ����ݱ��Ż��Ļ����ڴ�ռ�����ٿ��Խ���һ�룬�������Խ������֮�����ϣ���������Ż��� ��Ҫ�����������ݽṹ�������ݿ����й������������Ļ��ϵģ�û���Զ����������ɣ� ֻ�ܿ��ֹ������?�����Ҫ����Ա�Ծ���Ӧ����һ������Ϥ�̶ȣ�....... CPUռ������ʼ�ջ��ɸ����IIS�Ľű������йأ��������Ҳ���ʲô֤������ ������Լ����IIS��־����ݿ���־�ȷ���ȷ�������⣬�����������CPU�Ļ��� ����SQL������һ��CPUȥ�������?���������Ρ� �� Mon, 27 Mar 2006 23:37:05 +0800 ʱ, "С����(��)" <root@guohai.org.discuss> д��: -- >��һ��վ�շ�����2������ >SQL��ݿ����ڴ�С1G���ҡ� >��֪��Ϊʲô����SQL��CPUռ����ʼ������50%���ϣ��ڴ�ʹ����1.3G~1.5G֮ǰ[û���ڴ�����]������������� >�����Ӧ��������ֽ���� -- �������ǣ���Ȼһ����� Ҳϣ�������������Ĺ�â�� ��ӭ���� news://news.cn99.com/cn.fan �й�fans�������飬�й�fans�ļ�......
Technical Details
Message-ID:
<446ba1df.34170564@127.0.0.1>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!news.yaako.com!news.liuxing99.3322.org!not-for-mailReferences:
<44290635.15446210@cnusenet.3322.org>Show Full Headers
Complete Article Headers
X-Google-Thread: 104772,a1c12ac488f3034d X-Google-Thread: 107c7f,a1c12ac488f3034d X-Google-Attributes: gid104772,gid107c7f,public X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!news.yaako.com!news.liuxing99.3322.org!not-for-mail From: ����99 <bianlule@bianlule.3322.org> Newsgroups: microsoft.public.cn.sqlserver,cn.fan Subject: Re: SQLCPU���ڴ�ռ������ Date: Wed, 29 Mar 2006 23:06:54 +0800 Organization: BIANLULE-����99 <bianlule@cnuninet.com> http://bianlule.cn99.com http://bianlule.yeah.net http://bianlule.126.com Lines: 23 Sender: ����99 <bianlule@cn.fan> Message-ID: <446ba1df.34170564@127.0.0.1> References: <44290635.15446210@cnusenet.3322.org> Reply-To: ����99 <bianlule@bigfoot.com> NNTP-Posting-Host: 58.208.13.68 Mime-Version: 1.0 Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: 8bit X-Trace: news.yaako.com 1143644827 10700 58.208.13.68 (29 Mar 2006 15:07:07 GMT) X-Complaints-To: usenet@news.yaako.com NNTP-Posting-Date: Wed, 29 Mar 2006 15:07:07 +0000 (UTC) Summary: This is an Message of cn.* X-Newsreader: Forte Agent 1.8/32.548 X-Original-NNTP-Posting-Host: 127.0.0.1 X-Original-Trace: 29 Mar 2006 23:06:54 +0800, 127.0.0.1 X-Authenticated-User: bianlule