Viewing 15 posts - 18,961 through 18,975 (of 19,560 total)
double post
answered the primary post at http://www.sqlservercentral.com/Forums/Topic827726-360-1.aspx
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
December 2, 2009 at 1:37 pm
It looks like a key would be the wait type you are seeing.
You are experiencing SOS_SCHEDULER_YIELD waits. This is an indicator of cpu pressure and happens when a process...
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
December 2, 2009 at 1:36 pm
I have run into this in the past as well (multiple instances on a server but not all produce this error). The SPN Fix described in that KB article...
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
December 2, 2009 at 1:24 pm
First result from google shows:
download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/OracleSSIS.docx
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
December 2, 2009 at 1:13 pm
A couple more questions:
Are you setting up via GUI? Or are you setting up via TSQL Script?
http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx
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
December 2, 2009 at 1:09 pm
Do you have a firewall (windows or otherwise) between the two preventing communications on 5022 or 5023?
What version SQL server are both principal and mirror server?
When you ping the servers,...
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
December 2, 2009 at 1:07 pm
Licensing information available on the system:
http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
Since SQL 2005 does not automatically track licensing information anymore, your best bet to find licensing information is to contact your rep or find your...
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
December 2, 2009 at 12:57 pm
RUN
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
December 2, 2009 at 9:13 am
http://www.freevbcode.com/ShowCode.asp?ID=5081
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
December 1, 2009 at 5:55 pm
RBarryYoung (11/25/2009)
Jeff Moden (11/3/2009)
malli.chitturi (11/2/2009)
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
December 1, 2009 at 5:18 pm
This is a much simpler task in some other medium than TSQL as Barry suggested. From within tsql, you would end up making calls to another medium to accomplish...
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
December 1, 2009 at 4:50 pm
How does your disk configuration compare to the old box (i.e. what is the allocation unit size? Was the disk aligned on both servers?, raid configs? disk speed?)?
What about 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
December 1, 2009 at 3:27 pm
RBarryYoung (12/1/2009)
Alvin Ramard (12/1/2009)
CirquedeSQLeil (12/1/2009)
Simply amazing how quiet the.Thread is today....The Thread fell asleep at Thanksgiving and has yet to wake-up completely. ....
Probably eating too many Turkies...
and still eating that...
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
December 1, 2009 at 3:18 pm
An alternative would be to use dynamic sql to create your statements and then execute the statement that is necessary.
Another alternative would be to use an if/else statement.
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
December 1, 2009 at 3:17 pm
Try this
declare @Color varchar(10)
Set @Color = 'yellow'
;
with redcte as (select 'red' as one,'red' as two,'red' as three from sys.tables
union all
select 'yellow' as one,'yellow' as two,'yellow' as three from...
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
December 1, 2009 at 3:15 pm
Viewing 15 posts - 18,961 through 18,975 (of 19,560 total)