Viewing 15 posts - 13,201 through 13,215 (of 19,560 total)
Time to pull out the Jeff Dunham videos. Maybe start with the Christmas special. Need to get in a cheery mood.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 5:54 pm
Alvin Ramard (7/21/2010)
Grant Fritchey (7/21/2010)
rjohal-500813 (7/21/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 5:52 pm
Jalapeno .... on a stick
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 5:08 pm
Tom.Thomson (7/21/2010)
Steve Jones - Editor (7/21/2010)
CirquedeSQLeil (7/21/2010)
PaulB-TheOneAndOnly (7/21/2010)
Lynn Pettis (7/21/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 5:05 pm
Here is a reference article for setting the service accounts to a domain account:
http://msdn.microsoft.com/en-us/library/ms186264.aspx
This gives the instructions for the agent, but the same basic steps apply to the SQL Server...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 5:04 pm
PaulB-TheOneAndOnly (7/21/2010)
Lynn Pettis (7/21/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 4:55 pm
I would proceed cautiously. I think there is still adequate risk. I would probably try to test a few more scenarios.
Another possible solution, find out what it is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 4:24 pm
I run a Dell 17" recently upgraded to Win7. I have SQL 2005 and SQL 2008 installed. 2Gb memory which is a little on the short end for...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 11:11 am
GilaMonster (7/21/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 11:09 am
What is the error message that you get when you run the package as a scheduled job?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 11:06 am
Yes - that is a potential issue.
I would test a couple of scenarios in your dev environment. Try to perform that very action, document it and use that as...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 11:05 am
If it doesn't seem to be taxing the system heavily during use and just runs and runs and runs, you could setup a trace via profiler. Capture the data...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 11:01 am
From BOL
When ad hoc access is enabled, any user logged on to that instance can execute SQL statements that contain ad hoc connector names referencing any data source on the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 10:51 am
If the application is using a cursor to query the database, then you would need to modify the app.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 10:44 am
What kind of application is running this process?
Do you get an error message?
Does the process complete?
Does the process output desired results?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 21, 2010 at 10:41 am
Viewing 15 posts - 13,201 through 13,215 (of 19,560 total)