Profiler's not usually that heavy on a server, but it is a small load. Perhaps you could use server-side traces instead (Profiler will generate the scripts for you. Stick into...

Select ... into only creates and populates the table.

If you want indexes, constraints, primary key, triggers or anything else from the original table, you'll have to script them from...

Please don't cross post. You have an active topic for this question already.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic509461-9-1.aspx

Can you post the execution plan please, along with the table and index definitions? If you've ghanged the view please post the revised code.

It should be an either-or.

As soon as you enable /3GB, you're restricting the kernal to only 1 GB of memory. That's all it gets to run the core of the...

Profiler is not available for express.

You can get SQL Developer edition for around $50 which includes all the enterprise features, including profiler, and will install fine on XP.

avipenina (6/1/2008)

---

i'm responsible for more then 50 SQL Server 2005 Standard Edition thats run on 32BIT systems and use Windows Server 2003 32BIT and have 4GB MEM.

should i enable the...

Dunno.

Reading over the article it looks like he's mostly taking about the locked pages property than anything else.

See his clarification:

http://blogs.msdn.com/slavao/archive/2006/03/13/550594.aspx

Wilfred van Dijk (6/2/2008)

---

AWE is used for locking memory in a 64bit environment. So if you have al lot of memory, anable AWE and 'lock pages in memory'

If you don't...

Please don't cross post. It just wastes people's time.

Replies to the following thread please:

http://www.sqlservercentral.com/Forums/Topic509724-5-1.aspx

Distinct means that SQL will eliminate duplicate rows from the result set. If you don't have duplicate rows (which in your case you won't because of the group by) you...

In 2005 you can save the exec plans in xml formal (.sqlplan). you can open a sqlplan file in management studio to see the whole graphical plan.

Please don't cross post. It just fragments replies and wastes people's time.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic509676-5-1.aspx

Could you post the execution plans please. (in xml format)

Without that, we're guessing at best.

Also helpful would be the table and index definitions.

Run profiler against the server for a couple hours during your high CPU time. Events to monitor:

- Stored Procedures: RPC completed

- T-SQL:Batch Completed

The default columns should be good enough. Make...