Showing posts with label process. Show all posts
Showing posts with label process. Show all posts
Monday, March 19, 2012
Explain how to set the Total Mem Allocation using /3GB
/3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is it?
Can it be used to increase the Total memory allocation to a process? If so,
how is that process set?
Regards,
Jamie
the switch can be set in boot.ini on Windows 2K Adv.
Or do it using sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
Only if your Server has more than 2 GB of RAM
If you use the /PAE in Boot.ini and AWE in SQL 2000 Ent allows SQL
Server 2000 to utilize more than 4 GB memory
Without the /PAE switch SQL Server can only utilize up to 3 GB of
memory.
On Jan 22, 10:17 am, thejamie <theja...@.discussions.microsoft.com>
wrote:
> /3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is it?
> Can it be used to increase the Total memory allocation to a process? If so,
> how is that process set?
> --
> Regards,
> Jamie
|||/3GB is not used for SQL enterprise edition ONLY on Win2K Adv Server. You can
use it on 32-bit SQL2000/2005 enterprise edition with 32-bit Win2K/Win2K5
enterprise edition if you want the buffer pool of your SQL instance to use
more than 2GB of memory. (I only work with the enterprise editions of SQL
Server and Windows, so I can't comment on how it may behave on a
non-enterprise edition)
For some empirical data, see
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx.
Linchi
"thejamie" wrote:
> /3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is it?
> Can it be used to increase the Total memory allocation to a process? If so,
> how is that process set?
> --
> Regards,
> Jamie
|||Since it is the Standard SQL Ed, I suspect the AWE does nothing and that the
/3GB already implemented will give me the biggest bang for the buck. THere
is actually 6 GB available on the Windows Advanced Server 2000. The extra
RAM has reduced the cpu load... instead of an 80% RAM usage it is now 31%
but 31% is still, I think, just 2 GB which is as it should be.
Regards,
Jamie
"Linchi Shea" wrote:
[vbcol=seagreen]
> /3GB is not used for SQL enterprise edition ONLY on Win2K Adv Server. You can
> use it on 32-bit SQL2000/2005 enterprise edition with 32-bit Win2K/Win2K5
> enterprise edition if you want the buffer pool of your SQL instance to use
> more than 2GB of memory. (I only work with the enterprise editions of SQL
> Server and Windows, so I can't comment on how it may behave on a
> non-enterprise edition)
> For some empirical data, see
> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx.
> Linchi
> "thejamie" wrote:
Can it be used to increase the Total memory allocation to a process? If so,
how is that process set?
Regards,
Jamie
the switch can be set in boot.ini on Windows 2K Adv.
Or do it using sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
Only if your Server has more than 2 GB of RAM
If you use the /PAE in Boot.ini and AWE in SQL 2000 Ent allows SQL
Server 2000 to utilize more than 4 GB memory
Without the /PAE switch SQL Server can only utilize up to 3 GB of
memory.
On Jan 22, 10:17 am, thejamie <theja...@.discussions.microsoft.com>
wrote:
> /3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is it?
> Can it be used to increase the Total memory allocation to a process? If so,
> how is that process set?
> --
> Regards,
> Jamie
|||/3GB is not used for SQL enterprise edition ONLY on Win2K Adv Server. You can
use it on 32-bit SQL2000/2005 enterprise edition with 32-bit Win2K/Win2K5
enterprise edition if you want the buffer pool of your SQL instance to use
more than 2GB of memory. (I only work with the enterprise editions of SQL
Server and Windows, so I can't comment on how it may behave on a
non-enterprise edition)
For some empirical data, see
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx.
Linchi
"thejamie" wrote:
> /3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is it?
> Can it be used to increase the Total memory allocation to a process? If so,
> how is that process set?
> --
> Regards,
> Jamie
|||Since it is the Standard SQL Ed, I suspect the AWE does nothing and that the
/3GB already implemented will give me the biggest bang for the buck. THere
is actually 6 GB available on the Windows Advanced Server 2000. The extra
RAM has reduced the cpu load... instead of an 80% RAM usage it is now 31%
but 31% is still, I think, just 2 GB which is as it should be.
Regards,
Jamie
"Linchi Shea" wrote:
[vbcol=seagreen]
> /3GB is not used for SQL enterprise edition ONLY on Win2K Adv Server. You can
> use it on 32-bit SQL2000/2005 enterprise edition with 32-bit Win2K/Win2K5
> enterprise edition if you want the buffer pool of your SQL instance to use
> more than 2GB of memory. (I only work with the enterprise editions of SQL
> Server and Windows, so I can't comment on how it may behave on a
> non-enterprise edition)
> For some empirical data, see
> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx.
> Linchi
> "thejamie" wrote:
Explain how to set the Total Mem Allocation using /3GB
/3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is it
?
Can it be used to increase the Total memory allocation to a process? If so,
how is that process set?
--
Regards,
Jamiethe switch can be set in boot.ini on Windows 2K Adv.
Or do it using sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
Only if your Server has more than 2 GB of RAM
If you use the /PAE in Boot.ini and AWE in SQL 2000 Ent allows SQL
Server 2000 to utilize more than 4 GB memory
Without the /PAE switch SQL Server can only utilize up to 3 GB of
memory.
On Jan 22, 10:17 am, thejamie <theja...@.discussions.microsoft.com>
wrote:
> /3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is
it?
> Can it be used to increase the Total memory allocation to a process? If
so,
> how is that process set?
> --
> Regards,
> Jamie|||/3GB is not used for SQL enterprise edition ONLY on Win2K Adv Server. You ca
n
use it on 32-bit SQL2000/2005 enterprise edition with 32-bit Win2K/Win2K5
enterprise edition if you want the buffer pool of your SQL instance to use
more than 2GB of memory. (I only work with the enterprise editions of SQL
Server and Windows, so I can't comment on how it may behave on a
non-enterprise edition)
For some empirical data, see
http://sqlblog.com/blogs/linchi_she...>
icture.aspx.
Linchi
"thejamie" wrote:
> /3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is
it?
> Can it be used to increase the Total memory allocation to a process? If
so,
> how is that process set?
> --
> Regards,
> Jamie|||Since it is the Standard SQL Ed, I suspect the AWE does nothing and that the
/3GB already implemented will give me the biggest bang for the buck. THere
is actually 6 GB available on the Windows Advanced Server 2000. The extra
RAM has reduced the cpu load... instead of an 80% RAM usage it is now 31%
but 31% is still, I think, just 2 GB which is as it should be.
--
Regards,
Jamie
"Linchi Shea" wrote:
[vbcol=seagreen]
> /3GB is not used for SQL enterprise edition ONLY on Win2K Adv Server. You
can
> use it on 32-bit SQL2000/2005 enterprise edition with 32-bit Win2K/Win2K5
> enterprise edition if you want the buffer pool of your SQL instance to use
> more than 2GB of memory. (I only work with the enterprise editions of SQL
> Server and Windows, so I can't comment on how it may behave on a
> non-enterprise edition)
> For some empirical data, see
> http://sqlblog.com/blogs/linchi_she...
-picture.aspx.
> Linchi
> "thejamie" wrote:
>
?
Can it be used to increase the Total memory allocation to a process? If so,
how is that process set?
--
Regards,
Jamiethe switch can be set in boot.ini on Windows 2K Adv.
Or do it using sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
Only if your Server has more than 2 GB of RAM
If you use the /PAE in Boot.ini and AWE in SQL 2000 Ent allows SQL
Server 2000 to utilize more than 4 GB memory
Without the /PAE switch SQL Server can only utilize up to 3 GB of
memory.
On Jan 22, 10:17 am, thejamie <theja...@.discussions.microsoft.com>
wrote:
> /3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is
it?
> Can it be used to increase the Total memory allocation to a process? If
so,
> how is that process set?
> --
> Regards,
> Jamie|||/3GB is not used for SQL enterprise edition ONLY on Win2K Adv Server. You ca
n
use it on 32-bit SQL2000/2005 enterprise edition with 32-bit Win2K/Win2K5
enterprise edition if you want the buffer pool of your SQL instance to use
more than 2GB of memory. (I only work with the enterprise editions of SQL
Server and Windows, so I can't comment on how it may behave on a
non-enterprise edition)
For some empirical data, see
http://sqlblog.com/blogs/linchi_she...>
icture.aspx.
Linchi
"thejamie" wrote:
> /3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is
it?
> Can it be used to increase the Total memory allocation to a process? If
so,
> how is that process set?
> --
> Regards,
> Jamie|||Since it is the Standard SQL Ed, I suspect the AWE does nothing and that the
/3GB already implemented will give me the biggest bang for the buck. THere
is actually 6 GB available on the Windows Advanced Server 2000. The extra
RAM has reduced the cpu load... instead of an 80% RAM usage it is now 31%
but 31% is still, I think, just 2 GB which is as it should be.
--
Regards,
Jamie
"Linchi Shea" wrote:
[vbcol=seagreen]
> /3GB is not used for SQL enterprise edition ONLY on Win2K Adv Server. You
can
> use it on 32-bit SQL2000/2005 enterprise edition with 32-bit Win2K/Win2K5
> enterprise edition if you want the buffer pool of your SQL instance to use
> more than 2GB of memory. (I only work with the enterprise editions of SQL
> Server and Windows, so I can't comment on how it may behave on a
> non-enterprise edition)
> For some empirical data, see
> http://sqlblog.com/blogs/linchi_she...
-picture.aspx.
> Linchi
> "thejamie" wrote:
>
Sunday, February 26, 2012
exit job within a step
Hi,
I have a job with 6 steps. before I run steps 2 to 6 I check to see if there is data to process. I want to exit the job reporting success without running the other steps. How do I do this?
Thanks
Hi
I would add 2 additional steps to your job
Step1: Test if there is any data to load. If no - raise an error.
On Success - carry on
On Failure - go to step 8
Step 2- 7 your original steps, They'll never reach step 8.
Step 8: This will be your "dummy" step to make the load successfull if no data to load. It can be reached only from failure of Step 1.
Onother solution will be to use DTS package , where dataflow can be controlled much better and it can be schedules as well
NB.
|||Thanks,
This what I have done before. I was looking for a difference way.
Friday, February 17, 2012
execution plan for stored procedure?
Hi,
I'm brand new to SQL Server and have a question about execution plans
for stored procedures. It takes 10 minutes to process 10,000 rows
(seems excessive!) When I try to get an execution plan for the
procedure, it doesn't give me any information about the queries inside
the package, it just lists as one of the queries "query text: CREATE
PROCEDURE ....." and gives the cost relative to batch as zero.
For example, here's some of the script - I'll get a result for each of
the "set" statements, then the create, then the sets and grant at the
end. I've loaded the actual procedure from the DB and executed that
and then I get the same, except instead of the "create" statement as
one of the queries I get "object: Stored procedure xxx" but still
with zero cost.
Any help would be greatly appreciated! Sorry if my question doesn't
make sense, I hardly know enough to know what/how to ask! We're
taking the outline of our packaged software vendor's stored procedures
to base ours upon.
Thanks,
Pat
==============
USE AAD
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
IF EXISTS (SELECT * FROM sysobjects WHERE id =
object_id('dbo.usp_item_update_insert'))
BEGIN
PRINT 'Dropping old version of dbo.usp_item_update_insert'
DROP PROCEDURE dbo.usp_item_update_insert
END
GO
CREATE PROCEDURE usp_item_update_insert
@.v_vchMessage VARCHAR(500) OUTPUT
AS
(body of procedure)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS OFF
GO
GRANT EXECUTE ON usp_item_update_insert TO WA_USER, AAD_USER
GO
In Query Analyzer, select the "Query" menu and click "Show Execution Plan".
Then run the stored procedure and you will see the actual execution plan.
"Pat" <miapjp@.chartermi.net> wrote in message
news:f7a99267.0403310721.117e7f1b@.posting.google.c om...
> Hi,
> I'm brand new to SQL Server and have a question about execution plans
> for stored procedures. It takes 10 minutes to process 10,000 rows
> (seems excessive!) When I try to get an execution plan for the
> procedure, it doesn't give me any information about the queries inside
> the package, it just lists as one of the queries "query text: CREATE
> PROCEDURE ....." and gives the cost relative to batch as zero.
> For example, here's some of the script - I'll get a result for each of
> the "set" statements, then the create, then the sets and grant at the
> end. I've loaded the actual procedure from the DB and executed that
> and then I get the same, except instead of the "create" statement as
> one of the queries I get "object: Stored procedure xxx" but still
> with zero cost.
> Any help would be greatly appreciated! Sorry if my question doesn't
> make sense, I hardly know enough to know what/how to ask! We're
> taking the outline of our packaged software vendor's stored procedures
> to base ours upon.
> Thanks,
> Pat
> ==============
> USE AAD
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_WARNINGS ON
> GO
> IF EXISTS (SELECT * FROM sysobjects WHERE id =
> object_id('dbo.usp_item_update_insert'))
> BEGIN
> PRINT 'Dropping old version of dbo.usp_item_update_insert'
> DROP PROCEDURE dbo.usp_item_update_insert
> END
> GO
> CREATE PROCEDURE usp_item_update_insert
> @.v_vchMessage VARCHAR(500) OUTPUT
> AS
> (body of procedure)
> GO
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_WARNINGS OFF
> GO
> GRANT EXECUTE ON usp_item_update_insert TO WA_USER, AAD_USER
> GO
|||Pat,
You need to get the plan when you execute the proc, not when you create it. And that should be no problem. In
Query Analyzer, (Northwind), I have below:
EXEC dbo.CustOrderHist 123
When I press "Display Estimated Execution Plan", I do get a plan. Do you see something else?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Pat" <miapjp@.chartermi.net> wrote in message news:f7a99267.0403310721.117e7f1b@.posting.google.c om...
> Hi,
> I'm brand new to SQL Server and have a question about execution plans
> for stored procedures. It takes 10 minutes to process 10,000 rows
> (seems excessive!) When I try to get an execution plan for the
> procedure, it doesn't give me any information about the queries inside
> the package, it just lists as one of the queries "query text: CREATE
> PROCEDURE ....." and gives the cost relative to batch as zero.
> For example, here's some of the script - I'll get a result for each of
> the "set" statements, then the create, then the sets and grant at the
> end. I've loaded the actual procedure from the DB and executed that
> and then I get the same, except instead of the "create" statement as
> one of the queries I get "object: Stored procedure xxx" but still
> with zero cost.
> Any help would be greatly appreciated! Sorry if my question doesn't
> make sense, I hardly know enough to know what/how to ask! We're
> taking the outline of our packaged software vendor's stored procedures
> to base ours upon.
> Thanks,
> Pat
> ==============
> USE AAD
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_WARNINGS ON
> GO
> IF EXISTS (SELECT * FROM sysobjects WHERE id =
> object_id('dbo.usp_item_update_insert'))
> BEGIN
> PRINT 'Dropping old version of dbo.usp_item_update_insert'
> DROP PROCEDURE dbo.usp_item_update_insert
> END
> GO
> CREATE PROCEDURE usp_item_update_insert
> @.v_vchMessage VARCHAR(500) OUTPUT
> AS
> (body of procedure)
> GO
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_WARNINGS OFF
> GO
> GRANT EXECUTE ON usp_item_update_insert TO WA_USER, AAD_USER
> GO
|||OK, I was not executing it with the exec command, I have been
right-clicking on the sp, selecting open and then execute. Or
right-clicking and selecting edit and then the green execute arrow.
I've got it now.
Told you I was new!
Thanks much!
Pat
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<#H0KcTzFEHA.1128@.TK2MSFTNGP11.phx.gbl>...
> Pat,
> You need to get the plan when you execute the proc, not when you create it. And that should be no problem. In
> Query Analyzer, (Northwind), I have below:
> EXEC dbo.CustOrderHist 123
> When I press "Display Estimated Execution Plan", I do get a plan. Do you see something else?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Pat" <miapjp@.chartermi.net> wrote in message news:f7a99267.0403310721.117e7f1b@.posting.google.c om...
I'm brand new to SQL Server and have a question about execution plans
for stored procedures. It takes 10 minutes to process 10,000 rows
(seems excessive!) When I try to get an execution plan for the
procedure, it doesn't give me any information about the queries inside
the package, it just lists as one of the queries "query text: CREATE
PROCEDURE ....." and gives the cost relative to batch as zero.
For example, here's some of the script - I'll get a result for each of
the "set" statements, then the create, then the sets and grant at the
end. I've loaded the actual procedure from the DB and executed that
and then I get the same, except instead of the "create" statement as
one of the queries I get "object: Stored procedure xxx" but still
with zero cost.
Any help would be greatly appreciated! Sorry if my question doesn't
make sense, I hardly know enough to know what/how to ask! We're
taking the outline of our packaged software vendor's stored procedures
to base ours upon.
Thanks,
Pat
==============
USE AAD
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
IF EXISTS (SELECT * FROM sysobjects WHERE id =
object_id('dbo.usp_item_update_insert'))
BEGIN
PRINT 'Dropping old version of dbo.usp_item_update_insert'
DROP PROCEDURE dbo.usp_item_update_insert
END
GO
CREATE PROCEDURE usp_item_update_insert
@.v_vchMessage VARCHAR(500) OUTPUT
AS
(body of procedure)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS OFF
GO
GRANT EXECUTE ON usp_item_update_insert TO WA_USER, AAD_USER
GO
In Query Analyzer, select the "Query" menu and click "Show Execution Plan".
Then run the stored procedure and you will see the actual execution plan.
"Pat" <miapjp@.chartermi.net> wrote in message
news:f7a99267.0403310721.117e7f1b@.posting.google.c om...
> Hi,
> I'm brand new to SQL Server and have a question about execution plans
> for stored procedures. It takes 10 minutes to process 10,000 rows
> (seems excessive!) When I try to get an execution plan for the
> procedure, it doesn't give me any information about the queries inside
> the package, it just lists as one of the queries "query text: CREATE
> PROCEDURE ....." and gives the cost relative to batch as zero.
> For example, here's some of the script - I'll get a result for each of
> the "set" statements, then the create, then the sets and grant at the
> end. I've loaded the actual procedure from the DB and executed that
> and then I get the same, except instead of the "create" statement as
> one of the queries I get "object: Stored procedure xxx" but still
> with zero cost.
> Any help would be greatly appreciated! Sorry if my question doesn't
> make sense, I hardly know enough to know what/how to ask! We're
> taking the outline of our packaged software vendor's stored procedures
> to base ours upon.
> Thanks,
> Pat
> ==============
> USE AAD
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_WARNINGS ON
> GO
> IF EXISTS (SELECT * FROM sysobjects WHERE id =
> object_id('dbo.usp_item_update_insert'))
> BEGIN
> PRINT 'Dropping old version of dbo.usp_item_update_insert'
> DROP PROCEDURE dbo.usp_item_update_insert
> END
> GO
> CREATE PROCEDURE usp_item_update_insert
> @.v_vchMessage VARCHAR(500) OUTPUT
> AS
> (body of procedure)
> GO
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_WARNINGS OFF
> GO
> GRANT EXECUTE ON usp_item_update_insert TO WA_USER, AAD_USER
> GO
|||Pat,
You need to get the plan when you execute the proc, not when you create it. And that should be no problem. In
Query Analyzer, (Northwind), I have below:
EXEC dbo.CustOrderHist 123
When I press "Display Estimated Execution Plan", I do get a plan. Do you see something else?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Pat" <miapjp@.chartermi.net> wrote in message news:f7a99267.0403310721.117e7f1b@.posting.google.c om...
> Hi,
> I'm brand new to SQL Server and have a question about execution plans
> for stored procedures. It takes 10 minutes to process 10,000 rows
> (seems excessive!) When I try to get an execution plan for the
> procedure, it doesn't give me any information about the queries inside
> the package, it just lists as one of the queries "query text: CREATE
> PROCEDURE ....." and gives the cost relative to batch as zero.
> For example, here's some of the script - I'll get a result for each of
> the "set" statements, then the create, then the sets and grant at the
> end. I've loaded the actual procedure from the DB and executed that
> and then I get the same, except instead of the "create" statement as
> one of the queries I get "object: Stored procedure xxx" but still
> with zero cost.
> Any help would be greatly appreciated! Sorry if my question doesn't
> make sense, I hardly know enough to know what/how to ask! We're
> taking the outline of our packaged software vendor's stored procedures
> to base ours upon.
> Thanks,
> Pat
> ==============
> USE AAD
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_WARNINGS ON
> GO
> IF EXISTS (SELECT * FROM sysobjects WHERE id =
> object_id('dbo.usp_item_update_insert'))
> BEGIN
> PRINT 'Dropping old version of dbo.usp_item_update_insert'
> DROP PROCEDURE dbo.usp_item_update_insert
> END
> GO
> CREATE PROCEDURE usp_item_update_insert
> @.v_vchMessage VARCHAR(500) OUTPUT
> AS
> (body of procedure)
> GO
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_NULLS ON
> GO
> SET ANSI_WARNINGS OFF
> GO
> GRANT EXECUTE ON usp_item_update_insert TO WA_USER, AAD_USER
> GO
|||OK, I was not executing it with the exec command, I have been
right-clicking on the sp, selecting open and then execute. Or
right-clicking and selecting edit and then the green execute arrow.
I've got it now.
Told you I was new!
Thanks much!
Pat
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<#H0KcTzFEHA.1128@.TK2MSFTNGP11.phx.gbl>...
> Pat,
> You need to get the plan when you execute the proc, not when you create it. And that should be no problem. In
> Query Analyzer, (Northwind), I have below:
> EXEC dbo.CustOrderHist 123
> When I press "Display Estimated Execution Plan", I do get a plan. Do you see something else?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Pat" <miapjp@.chartermi.net> wrote in message news:f7a99267.0403310721.117e7f1b@.posting.google.c om...
Subscribe to:
Posts (Atom)