Procedure Time out: execution

Showing posts with label execution. Show all posts

Friday, March 30, 2012

profiler and showplan

I turn on profiler Performance/Execution Plan, and expect to see the
plan in the textdata field - but it's not there.
Is there some event class or other field or something that must also
be included that I've missed?
Thanks.
JoshWhich SQL profiler template have you selected? One of the template (standard)
displays TextData field.
Thanks
GYK
"JXStern" wrote:
> I turn on profiler Performance/Execution Plan, and expect to see the
> plan in the textdata field - but it's not there.
> Is there some event class or other field or something that must also
> be included that I've missed?
> Thanks.
> Josh
>|||On Wed, 27 Oct 2004 16:03:02 -0700, GYK
<GYK@.discussions.microsoft.com> wrote:
>Which SQL profiler template have you selected? One of the template (standard)
>displays TextData field.
I am capturing/displaying the textdata field, but it's empty on the
showplan lines, and in the statement lines I still see just the
statements. I used the SQLProfilerStandard template, and one of my
own, didn't seem to matter. I added all the TSQL events, that didn't
help either.
J.
>Thanks
>GYK
>"JXStern" wrote:
>> I turn on profiler Performance/Execution Plan, and expect to see the
>> plan in the textdata field - but it's not there.
>> Is there some event class or other field or something that must also
>> be included that I've missed?
>> Thanks.
>> Josh
>>|||You have to capture the Binary Data to see the Showplan output.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:9ta0o0d664jpr8ihme1kb2kngna64f721q@.4ax.com...
> On Wed, 27 Oct 2004 16:03:02 -0700, GYK
> <GYK@.discussions.microsoft.com> wrote:
>>Which SQL profiler template have you selected? One of the template
>>(standard)
>>displays TextData field.
> I am capturing/displaying the textdata field, but it's empty on the
> showplan lines, and in the statement lines I still see just the
> statements. I used the SQLProfilerStandard template, and one of my
> own, didn't seem to matter. I added all the TSQL events, that didn't
> help either.
> J.
>
>>Thanks
>>GYK
>>"JXStern" wrote:
>> I turn on profiler Performance/Execution Plan, and expect to see the
>> plan in the textdata field - but it's not there.
>> Is there some event class or other field or something that must also
>> be included that I've missed?
>> Thanks.
>> Josh
>>
>|||On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>You have to capture the Binary Data to see the Showplan output.
Wait a minute. I changed the template to capture BinaryData field,
and sure enough, now I got the Showplan tree - in the TextData field!
So I removed the BinaryData field, and now I *still* get the Showplan
tree in the TextData field. Even after I exit and restart Profiler!
Is this some weird bug in SQL2K, that you have to first ask for the
BinaryData, then you can stop asking for it, to get the Showplan tree?
Weird.
But it worked, so thanks!
Josh|||That IS weird. When I remove the binary data column I don't get the showplan
anymore.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:ebf0o0pldmaluufjgic4lstkb6ovectqob@.4ax.com...
> On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
>>You have to capture the Binary Data to see the Showplan output.
> Wait a minute. I changed the template to capture BinaryData field,
> and sure enough, now I got the Showplan tree - in the TextData field!
> So I removed the BinaryData field, and now I *still* get the Showplan
> tree in the TextData field. Even after I exit and restart Profiler!
> Is this some weird bug in SQL2K, that you have to first ask for the
> BinaryData, then you can stop asking for it, to get the Showplan tree?
> Weird.
> But it worked, so thanks!
> Josh
>|||What event are you capturing... showplan or execution plan?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:ebf0o0pldmaluufjgic4lstkb6ovectqob@.4ax.com...
> On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
>>You have to capture the Binary Data to see the Showplan output.
> Wait a minute. I changed the template to capture BinaryData field,
> and sure enough, now I got the Showplan tree - in the TextData field!
> So I removed the BinaryData field, and now I *still* get the Showplan
> tree in the TextData field. Even after I exit and restart Profiler!
> Is this some weird bug in SQL2K, that you have to first ask for the
> BinaryData, then you can stop asking for it, to get the Showplan tree?
> Weird.
> But it worked, so thanks!
> Josh
>|||On Wed, 27 Oct 2004 17:58:04 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>What event are you capturing... showplan or execution plan?
Execution plan.
J.|||On Wed, 27 Oct 2004 17:48:58 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>That IS weird. When I remove the binary data column I don't get the showplan
>anymore.
But when you get it, is it in the binary or text field?|||JXStern wrote:
> On Wed, 27 Oct 2004 17:58:04 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
>> What event are you capturing... showplan or execution plan?
> Execution plan.
> J.
Execution Plan only requires TextData. Show Plan, if I'm not mistaken,
requires BinaryData.
--
David Gugick
Imceda Software
www.imceda.com|||I just found this... not that it gives a whole lot more info, but at least
it's documented:
http://support.microsoft.com/default.aspx?scid=kb;en-us;272439
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OCy3cfKvEHA.1988@.TK2MSFTNGP12.phx.gbl...
> JXStern wrote:
>> On Wed, 27 Oct 2004 17:58:04 -0700, "Kalen Delaney"
>> <replies@.public_newsgroups.com> wrote:
>> What event are you capturing... showplan or execution plan?
>> Execution plan.
>> J.
> Execution Plan only requires TextData. Show Plan, if I'm not mistaken,
> requires BinaryData.
> --
> David Gugick
> Imceda Software
> www.imceda.com|||On Thu, 28 Oct 2004 22:46:23 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>I just found this... not that it gives a whole lot more info, but at least
>it's documented:
>http://support.microsoft.com/default.aspx?scid=kb;en-us;272439
Kinky (eg, a bug) but it doesn't explain the even weirder case I saw.
J.|||But we just have your word for it, right.
Have you been able to duplicate it?
;-)
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:vjs7o0lvo1o2799j6033qlc1ibk6ab9uo9@.4ax.com...
> On Thu, 28 Oct 2004 22:46:23 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
>>I just found this... not that it gives a whole lot more info, but at least
>>it's documented:
>>http://support.microsoft.com/default.aspx?scid=kb;en-us;272439
> Kinky (eg, a bug) but it doesn't explain the even weirder case I saw.
> J.
>|||On Sat, 30 Oct 2004 15:19:57 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>But we just have your word for it, right.
>Have you been able to duplicate it?
>;-)
Now that you ask, no.
I just tried it, and on a clean startup, this time I *did* get the
execution plan - *without* also getting the binary!
Looks random. Isn't that special?
:)
J.

Profiler - details of SP

How can I setup Profiler to track/watch the execution of the lines in a
stored procedure?
It looks like I just see exec sp_DoWork, as TextData.
I want to see the sql statements in the SP and how long they each take.
--
Thanks,
ThomasLLHi,
I am not sure whether this is possible...
But as soon as you have identified the SP thats taking time, why dont
you check the execution plan of that SP instead?
Thomas.LeBlanc@.NoSpam.Com wrote:
> How can I setup Profiler to track/watch the execution of the lines in a
> stored procedure?
> It looks like I just see exec sp_DoWork, as TextData.
> I want to see the sql statements in the SP and how long they each take.
> --
> Thanks,
> ThomasLL|||Hi Thomas
You can trace SP:StmtStarting and SP:StmtCompleted
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Thomas.LeBlanc@.NoSpam.Com"
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
news:560746F5-F88B-49A5-9A13-EF873EBDD161@.microsoft.com...
> How can I setup Profiler to track/watch the execution of the lines in a
> stored procedure?
> It looks like I just see exec sp_DoWork, as TextData.
> I want to see the sql statements in the SP and how long they each take.
> --
> Thanks,
> ThomasLL|||That gives me the duration of each Insert, Updaet and Select in the SP?
Thanks Karen, you are a blessing to the SQL Server community
--
Thanks,
Thomas
"Kalen Delaney" wrote:
> Hi Thomas
> You can trace SP:StmtStarting and SP:StmtCompleted
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
> "Thomas.LeBlanc@.NoSpam.Com"
> <ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
> news:560746F5-F88B-49A5-9A13-EF873EBDD161@.microsoft.com...
> > How can I setup Profiler to track/watch the execution of the lines in a
> > stored procedure?
> >
> > It looks like I just see exec sp_DoWork, as TextData.
> >
> > I want to see the sql statements in the SP and how long they each take.
> > --
> > Thanks,
> > ThomasLL
>
>|||SP:StmtCompleted can give you the duration of each statement in the SP.
Thanks for your kind words. Karen thanks you too. ;-)
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Thomas.LeBlanc@.NoSpam.Com"
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
news:CC7D6F54-4DE7-4DE8-B7CC-7904572FDF90@.microsoft.com...
> That gives me the duration of each Insert, Updaet and Select in the SP?
>
> Thanks Karen, you are a blessing to the SQL Server community
> --
> Thanks,
> Thomas
>
> "Kalen Delaney" wrote:
>> Hi Thomas
>> You can trace SP:StmtStarting and SP:StmtCompleted
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> http://sqlblog.com
>>
>> "Thomas.LeBlanc@.NoSpam.Com"
>> <ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
>> news:560746F5-F88B-49A5-9A13-EF873EBDD161@.microsoft.com...
>> > How can I setup Profiler to track/watch the execution of the lines in a
>> > stored procedure?
>> >
>> > It looks like I just see exec sp_DoWork, as TextData.
>> >
>> > I want to see the sql statements in the SP and how long they each take.
>> > --
>> > Thanks,
>> > ThomasLL
>>

Friday, March 23, 2012

processors replacement

Your execution plans are going to need updating. They are
developed using a combination of cpu, memory and disk
speed, so if one changes its going to effect the rest.
Its not a big job, just look up update statistics, then
watch your server fly...
Peter
"The best minds are not in government. If any were,
business would steal them away."
Ronald Reagan

>--Original Message--
>Hi,
>SQL Server 7.0 is running on WinNT 4.0, 4 processors 4G
>memory (3G used for sql server). We're going to replace
>these processors with the new, faster 4 processors. Is
>there any known problem we can expect regarding starting
>sql services and databases with new processors?
>TIA
>Armin
>.
>
They have to shut down the server to add the upgrades and all execution
plans are lost when you stop sql server anyway. And the plans are not
directly related to disk speed at all. Even CPU and memory are things that
are taken into account at run time and not necessarily at compile time. A
complex plan will always have a single and a parallel plan created the first
time it is run. At run time it is decided based on how busy the cpu's are,
memory available, etc that determine if the single threaded plan is used or
a parallel plan and how many threads generated.
Andrew J. Kelly SQL MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:766e01c494e9$304f2300$a301280a@.phx.gbl...[vbcol=seagreen]
> Your execution plans are going to need updating. They are
> developed using a combination of cpu, memory and disk
> speed, so if one changes its going to effect the rest.
> Its not a big job, just look up update statistics, then
> watch your server fly...
> Peter
> "The best minds are not in government. If any were,
> business would steal them away."
> Ronald Reagan
>

Friday, March 9, 2012

Processes blocking RESOURCE MONITOR, normal behaviour?

Today I ended up in a situation where I had a process with total six "subthreads" (identified by different execution context) (seen in Activity Monitor). All of these had blocking=1. The server didn't function properly, I don't know the details of these problems, since I was not present at that time. We had to kill the processes. What is the process id 1, "RESOURCE MONITOR" in SQL Server 2005, seen in Activity Monitor? Is it fatal if some processes are blocking RESOURCE MONITOR? How can one end up in such situation, is it normal or a bug somewhere?

The server is a 64-bit Windows server having SQL Server 2005 SP1.

Yesterday I had a CLR stored procedure running on another server. The procedure uses System.Data.SqlClient.SqlConnection to access this server. The procedure started about 11.4.2007 22:22. The procedure created a connection to the SQL Server and created a select that should return 1,5 million rows. During fetching the rows (about after 800 000 rows) the procedure crashes to an error:"".NET Framework execution was aborted by escalation policy because of out of memory. " Naturally the procedure couldn't close the SQL Server connections, since it was forced to end.

The details if the processes as seen from Actívity Monitor (I only have screenshots so I can't copy-paste...):

The main process:

Process id: 69

status: suspended

open transactions: 1

command: SELECT

Application: .NET SqlClient Data Provider

Wait time: 578

Wait type: ASYNC_NETWORK_ID

CPU: 1375

Physical IO: 22

Memory usage: 2

Last batch: 11.4.2007 22:22:05

Blocked by: 0

Blocking: 1

Execution context: 0

Two "subthreads", there are five similar.

Process id: 69

status: suspended

open transactions: 0

command: SELECT

Application: .NET SqlClient Data Provider

Wait time: 35293046

Wait type: CXPACKET

CPU: 4875

Physical IO: 2214

Memory usage: 2

Last batch: 11.4.2007 22:22:05

Blocked by: 0

Blocking: 1

Execution context: 1

Process id: 69

status: suspended

open transactions: 0

command: SELECT

Application: .NET SqlClient Data Provider

Wait time: 35293031

Wait type: CXPACKET

CPU: 4875

Physical IO: 2210

Memory usage: 2

Last batch: 11.4.2007 22:22:05

Blocked by: 0

Blocking: 1

Execution context: 2

The rest three subthreads differ from the above by having different wait time, CPU, physical IO and execution context.

Alright Chap,

You need to look at the "BLOCKED BY" rather than "BLOCKING" column.

The BLOCKING=1 means that this process is blocking another process.

Looking at the info you provided, the SPID 69 is not being blocked by any process.

Hope that helps.

Jag

|||

First off are you aware of the issue http://support.microsoft.com/kb/928083. I ask because one of its symptoms is the .NET framework message you mention and I just wanted to make certain you could eliminate it as a cause of that problem.

On the wait/blocking issue you may want to check out http://msdn2.microsoft.com/en-us/library/ms179984.aspx which describes the various wait states and a dynamic management view to look at them. The wait type that you are seeing (CXPACKET) is particularly associated with parallellisation of queries. There is a recommendation of trying reducing the degree of parallelism if you see a problem with this type of contention.

|||

Jag Sandhu wrote:

Alright Chap,

You need to look at the "BLOCKED BY" rather than "BLOCKING" column.

The BLOCKING=1 means that this process is blocking another process.

Looking at the info you provided, the SPID 69 is not being blocked by any process.

You are right, 69 is not blocking anything. I'm not interested in what 69 is blocking.

The problem is that 69 IS blocking SPID 1. SPID 1 is a system process, whose significance I don't know. During the problem 69 had been blocking 1 for a long time and the SQL server had been quite jammed. I was suspecting that the jamming was because the system process 1 couldn't do anythin being blocked by 69.

|||

Dhericean wrote:

First off are you aware of the issue http://support.microsoft.com/kb/928083. I ask because one of its symptoms is the .NET framework message you mention and I just wanted to make certain you could eliminate it as a cause of that problem.

Thanks for the information, I actually was unaware of the issue. This time I am not using a context connection, so the KB-entry is not valid in my case? I have two SQL Server instances and the CLR stored procedures run on instance A and use a "normal" SQL Server connection (instead of context connection) to connect to the server B.

Dhericean wrote:

On the wait/blocking issue you may want to check out http://msdn2.microsoft.com/en-us/library/ms179984.aspx which describes the various wait states and a dynamic management view to look at them. The wait type that you are seeing (CXPACKET) is particularly associated with parallellisation of queries. There is a recommendation of trying reducing the degree of parallelism if you see a problem with this type of contention.

OK, thanks for this information too. I find this CXPACKET issue also very strange since our database is in practise idle most of the time. And when this issue I reported happened the connection 69 had been in CXPACKET state for a while (don't know details, but maybe at least minutes). Shuoldn't the CXPACKET state change to something else after a while? Can this have something to do with the RESOURCE MONITOR process being blocked by process 69?

|||

Hi JM_F,

When BLOCKING column is set to 1 which means IT IS blocking another process. Other possible value for BLOCKING column is 0 which means it is not blocking any processes.

The values are 1 or 0 for Yes or NO respectively.

You have to use SP_who2 or DMV - sys.dm_exec_requests

and look for spid 69 in the BLOCKED by column.

regards

Jag

|||

Jag Sandhu wrote:

When BLOCKING column is set to 1 which means IT IS blocking another process. Other possible value for BLOCKING column is 0 which means it is not blocking any processes.

The values are 1 or 0 for Yes or NO respectively.

Hello Jag,

If I open Activity Monitor and click help, the following comes:

Blocked By
Process ID (SPID) of a blocking process.

Blocking
Process ID (SPID) of processes that are blocked.

This very clearly states that the value of blocking column contains the process ID. You say it contains 0 or 1. Are you sure of this?

|||

Hi JM,

To confirm, please see the books online topic - Activity Monitor (Process Info Page).

Process ID

SQL Server Process ID.

User

ID of the user who executed the command.

Database

Database currently being used by the process.

Status

Status of the process (for example, running, sleeping, runnable, and background).

Open Transactions

Number of open transactions for the process.

Command

Command currently being executed.

Application

Name of the application program being used by the process.

Wait Time

Current wait time in milliseconds. When the process is not waiting, the wait time is zero.

Wait Type

Indicates the name of the last or current wait type.

Resource

Textual representation of a lock resource.

CPU

Cumulative CPU time for the process. The entry is updated only for processes performed on behalf of Transact-SQL statements executed when SET STATISTICS TIME ON has been activated in the same session. The CPU column is updated when a query has been executed with SET STATISTICS TIME ON. When zero is returned, SET STATISTICS TIME is OFF.

Physical IO

Cumulative disk reads and writes for the process.

Memory Usage

Number of pages in the procedure cache that are currently allocated to this process. A negative number indicates that the process is freeing memory allocated by another process.

Login Time

Time at which a client process logged into the server. For system processes, the time at which SQL Server startup occurred is displayed.

Last Batch

Last time a client process executed a remote stored procedure call or an EXECUTE statement. For system processes, the displayed time is that at which SQL Server startup occurred.

Host

Name of the workstation.

Net Library

Column in which the client's network library is stored. Every client process comes in on a network connection. Network connections have a network library associated with them that allows them to make the connection. .

Net Address

Assigned unique identifier for the network interface card on each user's workstation. When the user logs in, this identifier is inserted in the Network Address column.

Blocked By

Process ID (SPID) of a blocking process.

Blocking

Indicates whether this process is blocking others. 1 = yes; 0 = no.

Execution Context

Execution context ID used to uniquely identify the subthreads operating on behalf of a single process.

|||

Jag Sandhu wrote:

To confirm, please see the books online topic - Activity Monitor (Process Info Page).

Blocking
Indicates whether this process is blocking others. 1 = yes; 0 = no.

Interesting... I found the entry you pointed in MSDN (http://msdn2.microsoft.com/en-us/library/ms178520.aspx). However the help page in my local installation (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/12f87b09-bf20-4a69-8333-e67419472337.htm) contains the description I sent before. So these descriptions don't match.

Can I assume this a bug in SQL Server local documentation?

I have SQL Server 2005 SP 1 on Windows XP.

regards,

|||MS does a very good job of keeping sql bol on msdn2 current. You should download the latest one from http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx|||

Hi JM,

Please get the latest bol.

By the way, BLOCKING thing is even same for SQL 2000. So its always been like that.

regards

Jag

Saturday, February 25, 2012

Process Cube using SQL DTS

Hi
I have created a package to do this which simply returns with the error
'1 task(s) failed during execution'. I can process the dimensions and
cubes manually in analysis Manager fine.
SQL and analysis Manager are both on the same server and the task
appears to be running with the domain administrator user.
Cany anyone help?
Cheers
Brettos.
brettos
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message542345.html
In workflow properties, set "Execute on main package thread", including all
packages that contains OLAP processing.
James Ma
"brettos" wrote:

> Hi
> I have created a package to do this which simply returns with the error
> '1 task(s) failed during execution'. I can process the dimensions and
> cubes manually in analysis Manager fine.
> SQL and analysis Manager are both on the same server and the task
> appears to be running with the domain administrator user.
> Cany anyone help?
> Cheers
> Brettos.
>
> --
> brettos
> Posted via http://www.webservertalk.com
> View this thread: http://www.webservertalk.com/message542345.html
>
|||To help in your debuging.
Open The package in design mode.
Right Click and Select "Package Properties"
Select The "Logging" tab.
Provide a log file location to use during processing of the package.
save and close the package.
Now run the package.
Open the log file and see what details you can gleam.
report back to us.
Hope this helps.
dlr
"brettos" <brettos.1gk5p2@.mail.webservertalk.com> wrote in message
news:brettos.1gk5p2@.mail.webservertalk.com...
> Hi
> I have created a package to do this which simply returns with the error
> '1 task(s) failed during execution'. I can process the dimensions and
> cubes manually in analysis Manager fine.
> SQL and analysis Manager are both on the same server and the task
> appears to be running with the domain administrator user.
> Cany anyone help?
> Cheers
> Brettos.
>
> --
> brettos
> Posted via http://www.webservertalk.com
> View this thread: http://www.webservertalk.com/message542345.html
>

Process Cube using SQL DTS

Hi
I have created a package to do this which simply returns with the error '1 t
ask(s) failed during execution'. I can process the dimensions and cubes man
ually in analysis Manager fine.
SQL and analysis Manager are both on the same server and the task appears to
be running with the domain administrator user.
Cany anyone help?
Cheers
Brettos.In workflow properties, set "Execute on main package thread", including all
packages that contains OLAP processing.
James Ma
"brettos" wrote:

> Hi
> I have created a package to do this which simply returns with the error
> '1 task(s) failed during execution'. I can process the dimensions and
> cubes manually in analysis Manager fine.
> SQL and analysis Manager are both on the same server and the task
> appears to be running with the domain administrator user.
> Cany anyone help?
> Cheers
> Brettos.
>
> --
> brettos
> ---
> Posted via http://www.webservertalk.com
> ---
> View this thread: http://www.webservertalk.com/message542345.html
>|||To help in your debuging.
Open The package in design mode.
Right Click and Select "Package Properties"
Select The "Logging" tab.
Provide a log file location to use during processing of the package.
save and close the package.
Now run the package.
Open the log file and see what details you can gleam.
report back to us.
Hope this helps.
dlr
"brettos" <brettos.1gk5p2@.mail.webservertalk.com> wrote in message
news:brettos.1gk5p2@.mail.webservertalk.com...
> Hi
> I have created a package to do this which simply returns with the error
> '1 task(s) failed during execution'. I can process the dimensions and
> cubes manually in analysis Manager fine.
> SQL and analysis Manager are both on the same server and the task
> appears to be running with the domain administrator user.
> Cany anyone help?
> Cheers
> Brettos.
>
> --
> brettos
> ---
> Posted via http://www.webservertalk.com
> ---
> View this thread: http://www.webservertalk.com/message542345.html
>

Friday, March 30, 2012

profiler and showplan

profiler and showplan

profiler and showplan

Profiler - details of SP

Profiler - details of SP

Profiler - details of SP

Friday, March 23, 2012

processors replacement

Friday, March 9, 2012

Processes blocking RESOURCE MONITOR, normal behaviour?

Saturday, February 25, 2012

Process Cube using SQL DTS

Process Cube using SQL DTS

Procedure Time out

Blog Archive

About Me