Viewing 15 posts - 6,136 through 6,150 (of 19,560 total)
Good to hear that it is resolved.
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
June 23, 2012 at 10:14 am
Brandie Tarvin (6/22/2012)
Daniel Bowlin (6/22/2012)
Ray K (6/22/2012)
quiet (where is everybody?)Slammed
Overwhelmed (need a time machine or a duplicator ala Calvin & Hobbes)
Slammed, overwhelmed, busy, need a moment to breath.
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
June 22, 2012 at 7:47 pm
The only tasks in the Maintenance Plan were to perform full, diff and t-log backups? Were there any other tasks? Was there another job that had restored 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
June 22, 2012 at 7:47 pm
If the package has been working and then failed this time then started working again, it is probably a network connectivity issue. It could also be that the remote...
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
June 22, 2012 at 5:38 pm
David Webb-200187 (6/22/2012)
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
June 22, 2012 at 4:42 pm
You're welcome.
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
June 22, 2012 at 9:07 am
Thanks for the back to basics question.
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
June 21, 2012 at 9:31 pm
I would make the effort to upgrade. There are new features that you will want to learn.
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
June 21, 2012 at 9:13 pm
Will you run this and post the results:
select serverproperty('edition') as Edition
,serverproperty('productversion') as ProductVersion
,serverproperty('productlevel') as ProductLevel
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
June 21, 2012 at 3:54 pm
This should do it
select
es.session_id,
er.database_id,
db_name(er.database_id) AS DBName
from
sys.dm_exec_sessions es
inner join sys.dm_exec_requests er...
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
June 21, 2012 at 3:49 pm
Koen Verbeeck (6/21/2012)
Lynn Pettis (6/21/2012)
OMGPlease, I really hope this person was joking.
Oh god not him.
He's the most important reason I have such a high post count. Trying to help him...
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
June 21, 2012 at 3:40 pm
cfradenburg (6/20/2012)
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
June 21, 2012 at 3:34 pm
Nothing to feel guilty about with the increase in productivity. At some point a realization will be met that the technology has also created more jobs - just different...
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
June 21, 2012 at 3:32 pm
It seems like you should be looking to do a traffic analysis using something like wireshark.
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
June 21, 2012 at 3:29 pm
Evil Kraig F (6/21/2012)
SQLRNNR (6/21/2012)
I know. That's why the space was left intentionally blank:-D:-D
Protip: Do not attempt to match wits on the thread after two days of intensive all...
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
June 21, 2012 at 1:52 pm
Viewing 15 posts - 6,136 through 6,150 (of 19,560 total)