Viewing 15 posts - 1,276 through 1,290 (of 19,560 total)
grkanth81 (5/21/2015)
unfortunately that was an issue from the vendor. They initially said that it is a date field and that was the reason I was trying...
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
May 22, 2015 at 9:53 am
GilaMonster (5/22/2015)
Please ask him to make sure that configurations are per the Microsoft KB articleshttps://support.microsoft.com/en-us/kb/2033238 and https://support.microsoft.com/en-us/kb/309422
IMHO - those recommendations are the lowest common denominator if you MUST have AV...
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
May 22, 2015 at 9:45 am
GilaMonster (5/22/2015)
audiocool (5/22/2015)
What is pending:1) McAfee (Can't make any changes as setting is been locked by corporate team. Local IT also can't do anything. Will proceed after received feedback)
And 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
May 22, 2015 at 9:40 am
Jack Corbett (5/22/2015)
My employer just finished a renovation and I'm...
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
May 22, 2015 at 8:49 am
GilaMonster (5/22/2015)
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
May 22, 2015 at 7:53 am
audiocool (5/21/2015)
SQLRNNR (5/21/2015)
What is the total memory allocated to this VM?
Do you have a memory reservation set for this VM...
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
May 21, 2015 at 9:50 pm
That article is wrong.
Best Practice is to set max memory.
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
May 21, 2015 at 9:15 pm
I don't recall reading it, so apologies if this is repetitive.
What is the total memory allocated to this VM?
Do you have a memory reservation set for this VM at 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
May 21, 2015 at 8:47 pm
Yes, you should set max memory on each instance.
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
May 21, 2015 at 8:40 pm
critter
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
May 21, 2015 at 5:58 pm
Alan.B (5/21/2015)
I have been told that numerous applications each today with their own database are to be migrated to a common database thereby requiring that all table/object names be prefixed...
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
May 21, 2015 at 5:57 pm
For this type of thing, I like having a proc they are permitted to execute that will perform an insert into a table. The table would contain the name...
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
May 21, 2015 at 4:45 pm
ramana3327 (5/21/2015)
I am working with one of the production database around 200 GB. This database has above 350 tables and more than 500 Indexes. I am feeling the database...
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
May 21, 2015 at 12:56 pm
Ed Wagner (5/21/2015)
DonlSimpson (5/21/2015)
cunningham (5/21/2015)
Ed Wagner (5/21/2015)
Stuart Davies (5/21/2015)
crookj (5/21/2015)
Revenant (5/21/2015)
Ed Wagner (5/21/2015)
parsonshenri (5/21/2015)
Mental blockHead
Master
Key
Stone
Rock
Roll
Jelly
Doughnuts
NOM NOM
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
May 21, 2015 at 12:12 pm
Steve Jones - SSC Editor (5/21/2015)
Lovely, isn't it? The deprecated algorithm is the default.
You're not surprised are you?:cool:
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
May 21, 2015 at 11:59 am
Viewing 15 posts - 1,276 through 1,290 (of 19,560 total)