Analytics Platform System
Analytics Platform System – a purpose-built, on-premises data warehouse platform – delivers rapid insights using massively parallel processing combined with big data integration to query across cloud and Hadoop clusters. APS is your on premises hub for all of your data: blazing fast performance; Insights from any data; engineered for value; the data warehouse you want.
More details about the Analytics Platform System are available in the APS documentation.
-
SSMS support for APS/PDW
I understand SSMS supports Azure DW, that should make it even easier to add the support for APS/PDW in SSMS.
55 votes -
Add "Allow access to Azure services" to Analysis Services firewall
Please add the option "Allow access to Azure services" to the analysis services firewall, the same way that the Azure SQL Server firewall has.
Processing the model is somehting i would like to do from Azure automation when i start the analysis server. Right now the only way to achieve that is to manually add all the datacenter ip ranges to the firewall manually.
31 votes -
Microsoft APS : Please increase Sessions from current 32 (Load 10 ,Query 22) to greater than 64
Microsoft APS : Please increase Sessions from current 32 (Load 10 ,Query 22) to greater than 64
Justification : in real world we are seeing more adhoc users usage + Loads so 32 is very small which is creating huge ripple effect on APS Query Performance & user satisfaction.
15 votes -
APS: Improve on control node bottleneck for data return rate
With AU4 it was claimed that the data return rate for APS should improve for select * queries
The real world improvements do not seem to exist from this feature and the control node seems to still be a big bottleneck for this kind of task being saturated with 100% CPU Load.
The scenario in which we need this is when processing a large cube with plenty of large partitions being processed in parallel.
Compare my screenshot for figures from our environment.
Specs:
APS HP Half rack (Patch: v10.0.8026.0)
40 core E7-8891 v2 512GB RAM + 12TB FusionIO SSAS only…13 votes -
Using APS PDW on-prem. Not having Primary Key Constraints is a big issue.
I've had to create an audit process using a control table that holds the primary key columns for all the tables and a procedure that spins through all the tables looking for duplicate counts based off those keys. After 2 years of adding tables with no validation for this, the first time I ran the audit 6 months ago, it found duplication in more than 10-20% of our tables. We're still cleaning up our legacy ETL feeds and removing duplicates. Looking for and cleaning up duplicates after they hit the system is very inefficient.
13 votes -
For APS PDW, add abiltiy to name indexes within the create table script and from visual studio script the indexes with thier names.
We have a naming standard for our indexes but since we can't script the name of the index in a create table command, we have to use a separate create index command. This is a bit of a hassle when moving objects around. Viewing the code of a table in Visual Studio does not include the index names so when we use this function we have to manually change the script it generates.
8 votes -
Add Compression with TDE backups
Hi,
When you enable TDE on database in PDW, AU7 it does not compress the backup, this results in double backup size than AU4. We have to enable TDE due to Security requirement as we have some personal information.
There is financial implication an more storage is required and more data to backup to tape. If service is handled by third party, then there is administration cost increased as well.Native SQL Server 2016 supports backup compression with TDE enabled. It is just matter or enabling as per bellow link:
4 votes -
Allow more than 4000 chars in DMVs
Extend DMVs definition in order to allow fields greater than 4000 chars, so to be able to see the entire text of a submitted command.
4 votes -
APS Backup to Name instead of IP
Right now the only supported way to backup APS is to an IP Address (UNC path), please add the ability to backup to a FQDN path.
4 votes -
3 votes
-
Please support Columnstore Indexes for tables which have Varchar(max)
Many of our tables have VARCHAR(MAX) columns which means we cannot use columnstore indexes. This limits performance of these tables. Please allow support for columnstore with varchar(max) as per SMP editions of SQL Server.
3 votes -
How to Factory Reset Windows 10 without Password
There is a simple and easy process to restore the hard drive to factory settings. It may be that your PC is not working well or hangs occasionally while working, or it may be that your PC hard drive is full and there is not enough space. Then you have to delete some content or format your PC. But instead of doing deleting you have another great option. You can either reset or restore your PC without any headaches. So how to windows 10 factory reset without password.
1: Factory Reset Windows 10 without Password
. Open Settings by typing…2 votes -
Change our Billing of three bills to united one bill
I have three Bills in 8,14,16 th from the month , our management and accountant need to make it all in one day 16th from the month will be easy to manage.
contacted technical support but they inform that this function is not available
1 vote -
Boost Your Metabolism Without Diet and Without exercise 100% Natural
Meticore is an all-natural dietary supplement that actively boosts one’s metabolism to promote healthy weight loss and detoxification of the body. As per the official website, the supplement is crafted after extensive research, and multiple trials run to ensure it effectively awakens the body’s metabolism to unlock one’s hidden weight loss potential. For a limited time, this supplement is available at a discounted price on the official website.https://meticoretrigger.blogspot.com/
1 vote -
Ala
-
_info.json 0 KB -
temperature.csv 0 KB -
steps.csv 0 KB -
soundlevel.csv 0 KB -
proximity.csv 0 KB -
signalstrength.csv 0 KB -
pressure.csv 0 KB -
pressure.csv 0 KB -
network.csv 0 KB -
magneticfield.csv 0 KB -
memory.csv 0 KB -
light.csv 0 KB -
gps.csv 0 KB -
humidity.csv 0 KB -
gyroscope.csv 0 KB -
gps.csv 0 KB -
cpu.csv 0 KB -
compass.csv 0 KB -
batterylevel.csv 0 KB -
accelerometer.csv 0 KB -
sensorlab_2018-10-07-10.17.03.zip 0 KB -
cello_standard_tuning.zip 0 KB -
root 2.xml 0 KB -
VCO.lcs 0 KB -
co3.mc 0 KB
1 vote -
-
Ey
Ey
1 vote -
We Explain Technology
The best technical question answer websites is tech treme. tech treme is one of the renowned and well-known websites for providing users cybersecurity releated query solution We Explain Technology
https://techtreme.com1 vote -
Canon printer error B200
If you encounter Canon Printer Error B200, you would like to easily turn-off the Canon printer for an hour then unplug its power line . then, open up the duvet, and check for objects that clog the printhead like paper clips. Remove such foreign objects just in case you see it, and switch on the printer by closing its cover. If this fails to resolve the B200 error code, then still read-out this blog.
The Canon printer error b200 be in progress when the print head perish. A print head distribute ink to the paper from the cartridges. It is…
1 vote -
majog22@hotmail.com
majog22
1 vote -
Prioritize workloads by login
Have the ability to prioritize workloads based on users.
In both ADW and APSWe have an APS that facilitate user queries and production processes.
In addition to resource groups I would like to have the ability to prioritize a login's workload over other login's.
e.g. Time sensitive Production process over user queries.
The requirement is to be able to differentiate workloads from service accounts and data exploration workloads.
This would prevent lower priority queries from saturating the 32 concurrency slots and give DBAs a mechanism to control this.If you have a login priority rank of 1 to 5. …
1 vote
- Don't see your idea?