Viewing 15 posts - 76 through 90 (of 153 total)
Curious are extracts from BizTalk as source to "some SQL Server" destination? Although not recommended, but seems to help is using (nolock) hint. Was not sure from message...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
October 8, 2013 at 4:08 am
inevercheckthis2002 (10/7/2013)
Steve Jones - SSC Editor (10/7/2013)
There are testing utilities, like SQLIO to measure raw performance.
With fourteen 15k RPM SAS drives in a RAID 10 array, at a generous 200...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
October 8, 2013 at 4:01 am
himanshu.sinha (9/17/2013)
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
September 17, 2013 at 8:37 pm
When doing a new SQL install, I asked for additional drives, It was mentioned to me that this is not done when storage is on a SAN because...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
September 17, 2013 at 3:10 am
Not sure if you were looking for other options? (Your post caught my eye - that msft had a data virtualization location)
I'm not affiliated with them, however I did see...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
September 17, 2013 at 3:04 am
So is sharepoint slow? Or you are just seeing this in DMV?
Questions:
1. Is this DMV giving cumulative values for io_stall_read_ms and io_stall_write_ms from last sql service restart?
Yes, that's correct,...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
September 17, 2013 at 2:54 am
berhanem 9188 (8/12/2013)
I hope your day is going well. I am tasked to move SQL Server 2008 DB, 2TB, which is in Simple Recovery Model, from local...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
August 13, 2013 at 3:56 am
GilaMonster (6/7/2013)
sqlsurfing (6/7/2013)
I wanted to see the internals if after the full index re-builds of all tables things are truly "de-fragmented"
If you've rebuilt the indexes, then the indexes are...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 7, 2013 at 8:34 pm
GilaMonster (6/7/2013)
Red Gate's got a tool to show you index fragmentation. Free tool last time I...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 7, 2013 at 2:53 pm
Does your Reporting Services Server have permissions to communicate with your SMTP Relay Server?
- Maybe a better question is, has this worked before or first time setting up email?
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 7, 2013 at 2:03 pm
dineshvishe (5/22/2013)
I want limit report server for cpu and memory.Thanks in Advance.
Hi please take a look at this link:
http://technet.microsoft.com/en-us/library/ms159206.aspx
Let me know if you have more questions, good luck!
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 6, 2013 at 1:01 pm
pnorlin (5/31/2013)
resolution:
Action performed by MS support personal on our server is:
Checked the connectivity through universal data link file:
1.by using Microsoft OLE DB Provider for...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 31, 2013 at 3:15 am
IgorMi (5/30/2013)
I want to see someone's explanation if there is a performance loss (and why in case of) when some VLFs are small and some are big, in a...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 30, 2013 at 4:57 pm
terry.home (5/27/2013)
I dont know whether the last six months worth of data is any smaller in comparison to...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 30, 2013 at 4:40 pm
The backups are no longer failing. They were failing due to lack of disk space and this has now been sorted, partly down to allocating more disk space, and partly...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
May 26, 2013 at 11:15 pm
Viewing 15 posts - 76 through 90 (of 153 total)