Trey, I apologise in that case. Thought I had to reply just in case there was a misunderstanding where I was coming from.

the dangers of written only communication.

If the above post was aimed at me sample databases should not be present on a production server because people should not be testing\learning on production servers.

Dev server, play to...

the two dmvs you want are sys.dm_db_index_operational_stats and sys.dm_db_index_usage_stats

these give stats on how often indexes are used and how many times they were used in a query plan (roughly...

Sounds like maybe the SOX compliance team has been in. These are exactly the type of carte blanche recommendations that are made.

If a reasoned argument can be provided as...

Oh dear. If you cannot get into SQL whilst experiencing that error the ONLY way out is to restart SQL.

How many CPUs have you got. For SQL to freeze there...

from a SQL perspective no different from any other migration.

Speak to your server guys, they may be able to do a P2V for you. (physical to virtual server copy)

sort of related to the blog ron posted profiler now contains a 'blocking' event that gives good information. You can tailor the threshold for reporting on blocks.

personally I would use...

same result

I can confirm it is not possible

ditto.

@mrakki

please still post back your results and final configuration, will be useful info

@brandie

sorry, was not ignoring you, just taking a different viewpoint.

thanks for the backing Cath, I wish people would believe ME sometimes. 🙂

I actually run SQL2005 SE 32bit with more than 4GB memory, so I know it works. definitive proof...

This is not a competition, I...

MrAkki, you have the configuration at your place of work, please try it out, you cannot do any harm.

Is there by any chance a message to the effect of

'Set AWE...

I believe you 🙂

andrew, will you describe...