Viewing 15 posts - 6,166 through 6,180 (of 19,560 total)
Revenant (6/20/2012)
EL Jerry (6/20/2012)
crookj (6/20/2012)
WOTD - PerennialEverlasting.
Green Fields
Emerald city
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 20, 2012 at 10:19 am
SQL Agent shouldn't take a port on startup. Has somebody configured an endpoint for it to use one of those ports?
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 20, 2012 at 10:03 am
Good to hear that it is the proper size after 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 19, 2012 at 4:45 pm
Some people use a startup proc that emails an alert.
Some may use some monitoring tools from 3rd parties.
Another possible option is to setup your own system that logs the tempdb...
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 19, 2012 at 3:38 pm
69GB, really?
What does this query result in?
select *
from sys.dm_os_performance_counters
Where instance_name = 'mssqlsystemresource'
And counter_name = 'Data File(s) Size (KB)'
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 19, 2012 at 1:54 pm
Sounds good, but I prefer cautious still. 😉
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 19, 2012 at 11:14 am
Nice to hear that diskkeeper has come that far. I prefer perfectdisk or defraggler. And as Gail mentioned, I would shut down the SQL Service. I have...
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 19, 2012 at 11:06 am
Stefan Krzywicki (6/19/2012)
SQLRNNR (6/19/2012)
Stefan Krzywicki (6/19/2012)
Wow, getting the Attunity drivers to work with Oracle is an enormous pain. This shouldn't be something that takes days to get right.
Are you really...
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 19, 2012 at 11:03 am
Stefan Krzywicki (6/19/2012)
Wow, getting the Attunity drivers to work with Oracle is an enormous pain. This shouldn't be something that takes days to get right.
Are you really that surprised? :hehe:
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 19, 2012 at 10:52 am
What did you use to determine that the SQL Agent service was using that port?
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 19, 2012 at 10:48 am
Thanks Ron.
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 19, 2012 at 10:29 am
Grant Fritchey (6/19/2012)
GilaMonster (6/19/2012)
Brandie Tarvin (6/19/2012)
"Surface"? Really?What kind of marketing department names a tablet with such a mundane moniker?
Surface was previously the name of their table computer (touch screen, about...
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 19, 2012 at 10:21 am
Brandie Tarvin (6/19/2012)
"Surface"? Really?What kind of marketing department names a tablet with such a mundane moniker?
It's almost as if they WANT the tablet to fail.
It could be worse - like...
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 19, 2012 at 10:18 am
WayneS (6/18/2012)
Me, your humble dba, from out of the blue, happened...
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 19, 2012 at 10:16 am
Daniel Bowlin (6/19/2012)
Ray K (6/19/2012)
Tuesday . . .afternoon . . .
I'm just beginning to see . . .
now I'm on my way . . .
Twilight Time
Vampires Suck
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 19, 2012 at 10:15 am
Viewing 15 posts - 6,166 through 6,180 (of 19,560 total)