Viewing 15 posts - 3,106 through 3,120 (of 19,560 total)
You can usually identify that you need more memory if you can see that you are experiencing memory pressure.
This is an article that helps to identify memory pressure
And this one
http://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/
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, 2014 at 4:07 pm
you are 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
May 21, 2014 at 4:05 pm
Aeterna (5/19/2014)
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, 2014 at 4:02 pm
david.gugg (5/21/2014)
I've always been successful by scripting the job to a new Query Editor Window, then changing the connection on that window to the destination server.
This is the same approach...
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, 2014 at 3:57 pm
You have used multicast to send data to two databases at the same time. You want to execute a stored procedure in each of those databases after the data...
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, 2014 at 3:44 pm
ihpk74 (5/21/2014)
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, 2014 at 3:29 pm
EventClass
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, 2014 at 3:23 pm
Multicast is the appropriate transformation to use.
From the additional information, it sounds like the same approach I would take.
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, 2014 at 3:17 pm
No. You won't be able to do that and use the GO command.
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, 2014 at 2:17 pm
Have you verified the existence of null values in the ProductVersion column?
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, 2014 at 9:09 am
Very good. Another superb example of implicit conversions gone wild.
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, 2014 at 9:03 am
Nice experiment Hugo. Saves me the effort!!
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, 2014 at 7:33 am
The same exact data into multiple tables?
or
Different pieces of data into different tables depending on the criteria?
There is so little information here, we'd really just be throwing around guesses 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 20, 2014 at 8:36 pm
Revenant (5/20/2014)
Ed Wagner (5/20/2014)
crookj (5/20/2014)
eccentricDBA (5/20/2014)
Ed Wagner (5/16/2014)
SQLRNNR (5/16/2014)
Ed Wagner (5/16/2014)
SQLRNNR (5/16/2014)
Ed Wagner (5/16/2014)
SQLRNNR (5/16/2014)
gyroscopicAxis
Allies
Board Game
Fun times
History (I know what you mean. I love playing strategy board games 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
May 20, 2014 at 8:27 pm
In that case, it really boils down to knowing your boss and your environment. Which metrics do you feel are important vs. which are important to the boss? ...
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 20, 2014 at 4:28 pm
Viewing 15 posts - 3,106 through 3,120 (of 19,560 total)