开发者

Should i use MAXDOP to improve my maintenance stored procedure?

Okay so i understand the basics of MAXDOP, but i want to understand if this a valid scenario for using it.

I have a stored procedure which is quite resource hungry, but has been optimized to the max. It currently takes 30 minutes (local) to refresh an entire system (what is refreshes isnt really important).

This procedure will get executed manually say once every couple of months, or as necessary.

Local (DEV) Server:

  • 4 CPU's
  • Windows 7
  • SQL Server 2008

Live Server:

  • 16 CPU's (i believe)
  • Windows Server 2008
  • SQL Server 2008.

Should i be using MAXDOP here? If it takes 30 minutes on my local, how fast 开发者_StackOverflow中文版would it (approximately) be with MAXDOP on live?

If so, how and where do i use it? The stored procedure calls other stored procedures, which call others, etc. If i specify MAXDOP for this stored procedure, will it retain this hint for all other stored procedures (ie in the scope of the parent stored procedure)?


I ended up not using MAXDOP - partially because no-one on Stack Overflow gave me any advice!!!! =)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜