(3) e.mail of security

yesterday and today receive e.mail from Microsoft sec.
not sure of sender. there are no update security for me
in HELP AND SUPPORT. Hare those e.mail realy from
MICROSOFTMicrosoft NEVER sends emails with security update attachments. You can
subscribe to mailing lists to receive Microsoft security bulletins or read
Microsoft security bulletins on the web. These bulletins NEVER contain
executable attachments, only references to web pages where you can access
Windows Update, download patches, or request to receive patches from
Microsoft Product Support Services.
You should never use any tool other than Automatic Updates, the Microsoft
Download Center, the Windows Update web site, or a response to your request
to Microsoft Product Support Services to install Windows security updates
or hotfixes. See
http://www.microsoft.com/technet/se.../patch_hoax.asp for an
explanation from Microsoft about these hoax email messages.
http://www.microsoft.com/technet/tr...chnet/security/
secnews/faq/faq1.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

%disk time > 2500

Is the %disk time > 2500 bad ? What does that mean ? My pages/sec seem to be
low ..around 0 with a few spikes here and there..so why is the %disk time
high ?
ThanksHi,
%disk time > 2500 , are you saying that your disk is running at 2500%, if
you are I want one of those disk :)
Can you tell me if you are using a software RAID 5 config? If so this might
explain the numbers. If you are using a software raid try dividing this
number by the number of disks. Although thinking a bit more I doubt
software RAID would explain the figure.
Basically PhysicalDisk:% Disktime shows how busy each disk is. long period
of busy times say over 50% for 10 minutes indicates problems (too many
writes/reads , slow disk) So a figure of 2500 is really saying something.
You should look to other counters like %disk read time %disk write time and
Avg Disk queue length to see where the issues are . If this activity is not
caused by paging then you have a very very busy machine.
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.asp. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.asp. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.asp. Free icon extraction
program
http://www.ag-software.com. Free programming tools
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O30Ol8LWDHA.392@.TK2MSFTNGP11.phx.gbl...
> Is the %disk time > 2500 bad ? What does that mean ? My pages/sec seem to
be
> low ..around 0 with a few spikes here and there..so why is the %disk time
> high ?
> Thanks
>

## How to acquire the SQL Server 2000 Performance data? ##

I want to write a application monitering program to collect the SQL
Server 2000 performance data,
such as pages/sec, bytes total/sec, etc, BUT I don't know how to do it
, In Oracle , there are the v$ views and DBA view , which I can find
the information I interested, the question is , is there a similar suit
of view in SQL Server 2000 to provide the performance information ?
Thank you very much, I will be mad by this question, for I have googled
all the day , but in vain(wangzhi0417@.gmail.com) writes:
> I want to write a application monitering program to collect the SQL
> Server 2000 performance data,
> such as pages/sec, bytes total/sec, etc, BUT I don't know how to do it
> , In Oracle , there are the v$ views and DBA view , which I can find
> the information I interested, the question is , is there a similar suit
> of view in SQL Server 2000 to provide the performance information ?
> Thank you very much, I will be mad by this question, for I have googled
> all the day , but in vain

Look at the table sysperfinfo.

In SQL 2005 this changes drastically. SQL 2005 exposes a lot more
information of this kind.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx