marrowyung
asked on
GPU processing power by SQL Server
Hi,
I know since a version of SQL server can make use of GPU processing and usually under what situation should we need that?
1) what is the known issue of it?
2) how to enable this feature?
3) How to verify this feature was enabled ?
4) how to disable this feature if we found the performance is worse than before?
5) should we only enable this feature on report server where large amount of data will be generate ?
I know since a version of SQL server can make use of GPU processing and usually under what situation should we need that?
1) what is the known issue of it?
2) how to enable this feature?
3) How to verify this feature was enabled ?
4) how to disable this feature if we found the performance is worse than before?
5) should we only enable this feature on report server where large amount of data will be generate ?
ASKER
SQL Server 2017/2019 Machine Learning Services and MicrosoftML packages only. Is it your case?for python or R programming?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
oh my god
If yes, then you may start here: https://docs.microsoft.com/en-us/archive/blogs/mlserver/get-started-with-microsoftmls-rxneuralnet-with-gpu-acceleration
This video may also say something about the subject: https://www.youtube.com/watch?v=Pu4dhJA8irU
Standard data processing and reporting cannot use GPU acceleration.