Viewing 15 posts - 316 through 330 (of 360 total)
My 2 cents..
Dont run the profiler on the server... run a server side profiler(script) through a job..that should have very less over head..also select only those events that you need..
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 28, 2011 at 11:27 am
Please find the activity monitor screen shot attached
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 28, 2011 at 9:47 am
I have very few databases that I am planning on HA...but the transaction rate is very high..almost 10 million inserts to one table a day
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 28, 2011 at 7:05 am
Thank You...I have scheduled to go on installing the updates on staging env. tonight. I will plan on monitoring for 1 week before I update the prod server.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 28, 2011 at 7:02 am
The last time the updates were run on this production DB server was in July,2011.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 27, 2011 at 2:07 pm
I meant anything other than using FailoverPartner in High performance mirroring.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 27, 2011 at 12:56 pm
Thanks for the info...so what are the best high availability options that we have where we need not worry about changing connection strings irrspective of automatic or manual failover?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 27, 2011 at 12:55 pm
Hi everyone,
Quick thing...Do we need to make changes to the connection strings of a web/app server config file if we implement DB mirroing in high performance automatic failover mode? I...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 27, 2011 at 11:31 am
I increased the size of the log for index rebuild and now want to release the unused space in the log. I did a transaction log backup with Truncate the...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 27, 2011 at 7:39 am
ok..thank you
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 26, 2011 at 10:31 pm
Also I forgot to mention that the DETA recommended to create a lot of statistics along with the indexes. Right now I am about to rebuild the indexes. Is it...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 26, 2011 at 9:58 pm
80
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 26, 2011 at 2:08 pm
Sure. I just verified again if any of our databases are shrinking through any maintenance plans or jobs and I don't see it happening.
Wondering why it happens so quickly.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 26, 2011 at 1:36 pm
The other thing I noticed is the indexes are fragmented heavily back within less than a week. I understand there are lots of inserts and updates happening. But is that...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 26, 2011 at 1:16 pm
Gail,
I dont see anything in the stored procedures folder and in the trace file I see sp_executesql followed by the queries and the trace was filtered with only a specific...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 26, 2011 at 1:06 pm
Viewing 15 posts - 316 through 330 (of 360 total)