Hello Everyone,

Running on Windows 2000 Advanced server service pack 4

I am attempting to simulate SQL IO Patterns using SQLIOSim and receiving
hundreds of VirtualProtect errors. See snippet below. I believe the function
is called during the transition of a page, located in the buffer pool, from
clean to dirty. Can this be a physical memory issue?



<ENTRY TYPE='ERROR' TIME='15:07:34' DATE='02/15/09' TID='4744' User='Initial
Update' File='e:\yukon\sosbranch\sql\ntdbms\storeng\util\s qliosim\buffer.cpp'
Line='104' Func='ChangePageProtection' HRESULT='0x800701E7' SYSTEXT='Attempt
to access invalid address.'>

<EXTENDED_DESCRIPTION>VirtualProtect (0x055CA000, 4)
failed</EXTENDED_DESCRIPTION>

</ENTRY>

Fred, thank you for reporting the error. This is a known issue with older
versions of SQLIOSim running on any version of Windows older than Windows
2003 SP1. The issue has been fixed in newer versions of SQLIOSim which can
be found in the free evaluation version of SQL Server. However, Windows 2000
will not be fully supported even in the new versions of SQLIOSim.

"FredG" wrote:

Hello Rusi_H,
I really appreciate your feedback.

I had no idea that a bug existed.

Will a licensed version contain the SQLIOSim tool as well?

"Rusi_H - MSFT" wrote:

Fred, SQLIOSim is included with all versions of SQL Server 2008. You can
find it in the Binn directory of your SQL Server 2008 installation.

--
SDE/T - SQL Server Engine


"FredG" wrote:

Thanks again Rushi_H, I was looking for it within my SQL 2K5 CD's

"Rusi_H - MSFT" wrote:

Hello Rusi_H,
I have extracted SQLIOSim from my SQL 2008 installation; unfortunately, I
receive the same VP errors.

"FredG" wrote: