Viewing 15 posts - 2,761 through 2,775 (of 18,926 total)
Has to be permissions!
September 12, 2011 at 3:13 pm
Any drive letter detached on the san?
NTFS permission changed?
Anything usefull in the sql error logs?
September 12, 2011 at 11:41 am
You'll have to use a job to send you the e-mail which will be 100% customizable.
In the alert ask to start a job, then use my query to generate usefull...
September 12, 2011 at 11:39 am
Bob Fazio (9/12/2011)
September 12, 2011 at 11:15 am
This can take a guess at the avg, min & max cost of the olap queries.
this uses the cached plan so it won't be 100% accurate but for guesstimate avg...
September 12, 2011 at 11:03 am
Steve Jones - SSC Editor (9/12/2011)
Gianluca Sartori (9/12/2011)
Thank you and...
September 12, 2011 at 10:55 am
Bob Fazio (9/12/2011)
Almost exclusive OLTP.
Unless Grant has something else in mind I'd go with Cost Treshold at 25-35. I'm going more on the low end here to get more...
September 12, 2011 at 10:48 am
The log file is harder to guess. But which such a small DB, I'd probably go with 3X of the sum of the 2 biggest tables.
Why did you split...
September 12, 2011 at 10:42 am
Ninja's_RGR'us (9/12/2011)
The cost threshold is however at 1 with the default value being 5. This might be something I'd...
September 12, 2011 at 10:40 am
I wouldn't take any decision based on those stats.
The cost threshold is however at 1 with the default value being 5. This might be something I'd consider...
September 12, 2011 at 10:36 am
I'd use a calendar table for this.
Here's mine http://www.sqlservercentral.com/Forums/Attachment8839.aspx
You can edit out the filegroup, I don't put mine on default.
From there on out it's just a matter of using the...
September 12, 2011 at 10:30 am
Bob Fazio (9/12/2011)
http://weblogs.sqlteam.com/tarad/archive/2010/11/08/max-degree-of-parallelism-server-side-setting.aspxFYI, for me it recommends 4, but as I said, I set to 6.
Ok, as I said, not even junior at tuning that big of a server. ...
September 12, 2011 at 10:29 am
Tx, and now these 2?
SELECT* FROM sys.dm_exec_query_optimizer_info
Don't do any of the recommendations, it's just very rough guidelines for us.
SELECT
optz.counter
, optz.occurrence
, CONVERT(DECIMAL(18,2),...
September 12, 2011 at 10:26 am
Bob Fazio (9/12/2011)
However, I should have clarified the 4th number. The other three were ignorable waits. In fact, all in...
September 12, 2011 at 10:14 am
Why 5 filegroups for this, this is very advanced tuning? Why such a small autogrowth?
With instant file initialization you could go to at least 1 GB
=> http://sqlskills.com/blogs/Kimberly/post/Instant-Initialization-What-Why-and-How.aspx
September 12, 2011 at 10:07 am
Viewing 15 posts - 2,761 through 2,775 (of 18,926 total)