191 reputation
7
bio website
location San Juan Capistrano, CA
age
visits member for 3 years
seen May 18 at 18:59

Eric Johannsen

VP of Engineering at BlueCava

http://www.bluecava.com

Email: my first name at my last name dot us


Feb
27
comment Estimating IO Requirements for Bursty Usage
I'll have to get some statistics on the overall size of the index and the percentage of that index typically accessed by a given query to answer your question.
Feb
27
comment Estimating IO Requirements for Bursty Usage
@JackDouglas: The largest reads are via an indexed view, such that the WHERE clause corresponds to the index, but returning more data than just what is in the index. I'm not sure what that means for the degree of sequential IO. Since the underlying IO subsystem is AWS EBS, I'm not sure how that impacts physical access.
Feb
26
comment Estimating IO Requirements for Bursty Usage
@JackDouglas: This is 98% reads. There is a trickle of writes.
Feb
26
accepted Estimating IO Requirements for Bursty Usage
Feb
26
comment Estimating IO Requirements for Bursty Usage
@MikeFal: Do you have any thoughts on the testing methodology specifically for this bursty pattern? Just run a single query and watch the counters in question? Run a number of the (normally periodic) queries one after another, watching the counters?
Feb
26
awarded  Commentator
Feb
26
comment Estimating IO Requirements for Bursty Usage
Thank you for the detailed answer. AWS now has a premium feature called Provisioned IOPS that ensures that the purchased number of IO operations per second can be performed 99.9% of the time. I think an IO operation is defined as reading or writing a 16K block of data.
Feb
26
asked Estimating IO Requirements for Bursty Usage
May
30
awarded  Popular Question
Apr
3
accepted Executing sys.dm_fts_parser without sysadmin server role
Apr
1
comment Executing sys.dm_fts_parser without sysadmin server role
The answer really came from a Stack Overflow user. The whole topic was deleted on SO because both the question and answer were copied to MSDN (apparently some user not the original answerer was gaming both sites) and SO didn't want to have any copyright issues. I'll see if I can find a way to reach the original SO answerer. Thank you for your help and I appreciate the advice to use a separate DB to minimize the security exposure.
Apr
1
comment Executing sys.dm_fts_parser without sysadmin server role
I tried it (by literally executing every step) but it did not work for me. Can you see any details left out of any step that DBA would just fill in but a non-DBA might miss? On a separate note, your blog on logins vs. users was very useful to me.
Apr
1
comment Executing sys.dm_fts_parser without sysadmin server role
There's another approach discussed on MSDN. Unfortunately I could not get that to work. Would you mind having a look and sharing whether you think it should work in principal? social.msdn.microsoft.com/Forums/en-US/transactsql/thread/…
Mar
31
asked Executing sys.dm_fts_parser without sysadmin server role
Oct
27
awarded  Critic
Oct
27
comment Save Results as CSV *with* headers in SSMS
If that were strictly true, it should not have any export option at all. For any software, if you add a feature, make it work right. At least SSMS 2008R2 fails that test when it comes to exporting. Additionally, SSMS actually can satisfy the OP's need.
Oct
11
awarded  Editor
Oct
11
comment Scripting a Backup Process and Backup File Ownership
@SqlRyan: Added the script and source to a short C# program that does the S3 upload. If you find a functional, command-line S3 client for Windows please let me know. s3.codeplex.com crashed when I ran it, and it is no longer maintained.
Oct
11
revised Scripting a Backup Process and Backup File Ownership
added 7411 characters in body
Oct
11
awarded  Scholar