Viewing 15 posts - 9,016 through 9,030 (of 19,560 total)
It won't work until 8/18, but here is a link for a post I wrote on the topic.
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
August 17, 2011 at 3:55 pm
Leo.Miller (8/17/2011)
SQLRNNR (8/17/2011)
You have 2 sockets and 8 processors.
Except if you licence Per Processor, you only pay for 2 licences, not 8.
This took me for ever to get my head...
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
August 17, 2011 at 2:08 pm
As Leo said, check the scripts and verify them. If you have tsql scripts in the commands with GO statements it could foul up the execution of your scripts.
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
August 17, 2011 at 2:02 pm
You have 2 sockets and 8 processors.
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
August 17, 2011 at 2:00 pm
Jim Murphy (8/16/2011)
Also, one of my larger DBA clients is doing a massive conversion from a dreaded SQL7 install (325GB DB) to a totally new vendor app, SQL2008, 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
August 17, 2011 at 1:48 pm
Evil Kraig F (8/17/2011)
jcrawf02 (8/17/2011)
ALZDBA (8/17/2011)
Evil Kraig F (8/17/2011)
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
August 17, 2011 at 1:31 pm
Grant Fritchey (8/17/2011)
Perry Whittle (8/17/2011)
Steve Jones - SSC Editor (8/16/2011)
Best advice, use backup compression first. If you have Enterprise Edition, you can use that
not available in SQL Server 2005, you...
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
August 17, 2011 at 1:30 pm
I would also verify that there is only one instance on that server.
It is a named instance, are you connecting to like the following:
Servername\InstanceName
or just
Servername
?
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
August 17, 2011 at 1:27 pm
bcsims 90437 (8/17/2011)
SQLRNNR (8/17/2011)
crookj (8/17/2011)
bopeavy (8/17/2011)
crookj (8/17/2011)
Daniel Bowlin (8/17/2011)
--------------------------------------------------------------------------------
Ray K (8/16/2011)
--------------------------------------------------------------------------------
busy
body
Bag
of Tricks
Bag of Doughnuts
Crave
Indulge
Indigent
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
August 17, 2011 at 11:03 am
crookj (8/17/2011)
bopeavy (8/17/2011)
crookj (8/17/2011)
Daniel Bowlin (8/17/2011)
--------------------------------------------------------------------------------
Ray K (8/16/2011)
--------------------------------------------------------------------------------
busy
body
Bag
of Tricks
Bag of Doughnuts
Crave
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
August 17, 2011 at 10:38 am
Is it a named instance? How are you trying to connect? Do you get an error message?
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
August 17, 2011 at 10:38 am
I'm in favor of adding disks. I am also in favor of implementing filegroup backups. The drawback to this is the time it will take you to figure...
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
August 17, 2011 at 10:37 am
jcrawf02 (8/17/2011)
SQLRNNR (8/17/2011)
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
August 17, 2011 at 10:32 am
I am not entirely a fan of getting a cell-phone from work. Too often the implication is that you must be ready to work 24x7x365 if they provide 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
August 17, 2011 at 10:05 am
Koen Verbeeck (8/17/2011)
Easy one today, although it seems the 'truncate is not logged'-myth stills seems pretty persistent.
Too persistent -it's like a nasty virus.
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
August 17, 2011 at 9:48 am
Viewing 15 posts - 9,016 through 9,030 (of 19,560 total)