Viewing 15 posts - 18,271 through 18,285 (of 19,560 total)
shahid00704 (1/8/2010)
i asks the moderator to please delete this post... i think i made a mistake by posting here my problem....
I disagree that a mistake was made in posting 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
January 9, 2010 at 11:29 am
Nice one Jeff. I missed it the first time around (and never searched for anything that pulled it up here at SSC). Adding this one to my reference...
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
January 9, 2010 at 11:17 am
That is extremely annoying. Some PMs and some emails is one thing - but then to go to the next medium.
If it is somebody I know, I would be...
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
January 9, 2010 at 10:59 am
AndrewSQLDBA (1/9/2010)
I greatly appreciate the code samples given by Jason, I will keep that one in my stash...
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
January 9, 2010 at 10:44 am
drew.403 (1/8/2010)
Is it possible to have a select statement (or 2) return the records? again I'm using a webserver and need it to be able to run from code in...
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
January 8, 2010 at 6:53 pm
Jeffrey Williams-493691 (1/8/2010)
CirquedeSQLeil (1/8/2010)IMO - static ports. This will help to prevent connection issues due to port changes.
Every Instance must be on a different port - otherwise SQL server...
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
January 8, 2010 at 6:49 pm
BTW - 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
January 8, 2010 at 5:41 pm
rambilla4 (1/8/2010)
1. Dynamic ports for all named instances
2. Set a static port for all named...
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
January 8, 2010 at 5:40 pm
Server Configuration Manager --> TCP/IP properties --> IP Addresses -->TCP port should have something and dynamic should not.
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
January 8, 2010 at 4:38 pm
ALZDBA (1/8/2010)
It is indeed a good way with minimal impact and no modification of existing stuff.
FWIW...
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
January 8, 2010 at 3:52 pm
A method I have used in the past was similar but only worked for 2005. However, I did not modify any procs.
I setup a daily job to run 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
January 8, 2010 at 3:17 pm
rambilla4 (1/8/2010)
The port will be dynamically assigned each time the service restarts. If you want a specific port, you will need to change the Port to a static one.
In Our...
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
January 8, 2010 at 3:14 pm
The port will be dynamically assigned each time the service restarts. If you want a specific port, you will need to change the Port to a static one.
http://msdn.microsoft.com/en-us/library/ms177440.aspx
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
January 8, 2010 at 3:02 pm
Check out this article.
http://searchsqlserver.techtarget.com/news/article/0,289142,sid87_gci1102101,00.html
With the new SQL Server 2005 security features, SQL Server logins will have all the same security policy features available. Both SQL Server users and application roles...
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
January 8, 2010 at 3:00 pm
Krasavita (1/8/2010)
How to check if I have enough memory on a instanse
It is a process. You need to monitor the servers. Check out this Blog - it should...
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
January 8, 2010 at 2:49 pm
Viewing 15 posts - 18,271 through 18,285 (of 19,560 total)