🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: microsoft.public.cn.sqlserver
Article #13

Re: SQLCPU���ڴ�ռ������

#13
From: pack27
Date: Thu, 30 Mar 2006 04:58
28 lines
2509 bytes
�Ǻǣ���˵�ò������

�ұ�������˼�ǣ�������Ϊ˫CPU������CPUռ����50%������CPU�Ļ���Ӧ����100%��

ӡ�����¼���̽�����Ը���SQL���¼�������


"С����(��)" <root@guohai.org.discuss> д����Ϣ 
news:442a8533.1559111@cnusenet.3322.org...
> ����˫CPU�й�
> ������˫CPU��Ȼ��ÿ��CPU�����dz��̵߳�
> ��ǿ2.8
> ��̽�����ܿ���ʲô����
> ��Wed, 29 Mar 2006 13:09:33 +0800ʱ,"pack27"�� ��Re:
> SQLCPU���ڴ�ռ������ ���з���Ĵ���:
> --
>
>>50%�Dz�����Ϊ˫CPU���߳��̣߳�
>>��SQL�ġ��¼�̽����������һ�¡�
>>
>>
>>"С����(��)" <root@guohai.org.discuss> д����Ϣ
>>news:44290635.15446210@cnusenet.3322.org...
>>> ��һ��վ�շ�����2������
>>> SQL��ݿ����ڴ�С1G���ҡ�
>>> ��֪��Ϊʲô����SQL��CPUռ����ʼ������50%���ϣ��ڴ�ʹ����1.3G~1.5G֮ǰ[û���ڴ�����]�������������
>>
> 
Technical Details
Message-ID: <e0fp6l$lo6$1@news.yaako.com>
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!not-for-mail
References: <44290635.15446210@cnusenet.3322.org> <e0d4qb$t94$2@news.yaako.com> <442a8533.1559111@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!not-for-mail
From: "pack27" <pack27@21cn.com>
Newsgroups: microsoft.public.cn.sqlserver,cn.fan
Subject: Re: SQLCPU���ڴ�ռ������
Date: Thu, 30 Mar 2006 12:58:23 +0800
Organization: Bentium Ltd. (CN99)
Lines: 30
Message-ID: <e0fp6l$lo6$1@news.yaako.com>
References: <44290635.15446210@cnusenet.3322.org> <e0d4qb$t94$2@news.yaako.com> <442a8533.1559111@cnusenet.3322.org>
NNTP-Posting-Host: 61.140.120.242
X-Trace: news.yaako.com 1143695382 22278 61.140.120.242 (30 Mar 2006 05:09:42 GMT)
X-Complaints-To: usenet@news.yaako.com
NNTP-Posting-Date: Thu, 30 Mar 2006 05:09:42 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
X-RFC2646: Format=Flowed; Original