Viewing 15 posts - 46,306 through 46,320 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2008 at 12:05 am
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 8:06 am
avipenina (6/1/2008)
should i enable the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 7:37 am
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 7:21 am
Wilfred van Dijk (6/2/2008)
If you don't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 7:00 am
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 6:44 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 6:38 am
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 5:16 am
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 5:14 am
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 5:11 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 5:05 am
jryan_pun (6/1/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2008 at 12:24 am
Please post your question so that we can try to help you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2008 at 9:40 am
Please don't cross post. It just fragments replies and wastes people's time. Many of the regulars read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic509190-19-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2008 at 9:32 am
Please don't cross post. It just fragments replies and wastes people's time. Many of the regulars read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic509190-19-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2008 at 9:30 am
Viewing 15 posts - 46,306 through 46,320 (of 49,552 total)