Performance problem loading packages

We're having a performance problem with a package since an error occurred. The original error came from the Job Manager whicj was unable to start a thread. Our understanding is that this is a memory related issue and we'll deal with that.

What is realy odd is what happened after that. The package executes from a SQL Agent job that includes 3 other packages. Each package is stored on the file system. Package execution time for the affected package changed from less than a minute to over 5 minutes. The other packages continued to execute normally.

In checking the logs there is large time gap between the start of the SQL Agent step and the first pre-validation message that accounts for 4 minutes, as if there is some issue in loading the package. The issue is ongoing. Does anyone know what happens between the start of the SQL Agent job and the first prevalidate message? Is this some type of caching issue?

SQL Agent step starts at 4:05:27

First Prevalidate message: 4:09:24

Package Execution start: 4:09:57

End Execution 4:10:59

thanks

Peter

Rebooting the server fixed the immediate problem.

Performance Point - Unable to create a data source

I m unable to create a data source from the scorecard builder of performance point server. Whatever options i try it gives me the error "Database connection failed. Please CONTACT YOUR ADMINISTRATOR" But I m the builtin administrator and I cannot find out whatsoever with this error message. Can anyone please help me with this?

TIA

What is the authentication mode used to connect to SQL?

Can you check whether you can connect to SQL server using SQL tools/

|||

I m able to connect using the SQLServer management studio.

The mode of authentication it says is standard. I tried also the option of giving connection string but in vain. I get the same error.

performance objects for SQLServer disappeared

Using SS2000. I have been several performance monitor counters for SQLServer.
When I tried to start the counters this morning, I received this error:
The database_size log or alert has not started.
When I tried to look at the counter, under performance object there are no
objects for SQLServer.
Does anyone know why or how these could disappear? SQL Server is still
running on the box.
Thanks,
--
Dan D.Have a look at this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k
--
Andrew J. Kelly SQL MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:68581C5F-771A-47D6-8B75-180D4B23D5AF@.microsoft.com...
> Using SS2000. I have been several performance monitor counters for
SQLServer.
> When I tried to start the counters this morning, I received this error:
> The database_size log or alert has not started.
> When I tried to look at the counter, under performance object there are no
> objects for SQLServer.
> Does anyone know why or how these could disappear? SQL Server is still
> running on the box.
> Thanks,
> --
> Dan D.