Hi
Would you mind advising which Microsoft SQL versions are supported / recommended
Is MS SQL Express 2019 suitable (given its memory / storage limitations) ? or is a licensed version of Standard edition required?
Thank you.
Which versions of MS SQL are supported?
-
-
How many images do you want to store?
Marcel
-
Hi Marcel, What is the best way to see that? Is that information visible within the CQ server application?
-
I think the express version may be fine, but is has a size limit. This would probably be hit at around 10M images. For that size SQLite is still fine.
Marcel
-
Thanks Marcel
Is there an easy way to determine the current image count?
-
Hm, not really; you could do a global image query but that may run out of memory. Of course the SQL console should tell you. What server are you using now?
-
-
Ok, in old SQL servers (without additional indices which are needed) 6M images took about 3GB of storage, so 7M may be close to the limit of SQL express.
Marcel
-
Thanks for that information. Appreciate your help
With regard to additional indices, is this something that we should have?
-
Yes,
Having joint indices:
study: patientID studyinstanceuid
series: studyinstanceuid seriesinstanceuid
image: seriesinstanceuid sopinstanceuid
Is a good idea
Marcel
-
Hi,
To add to this topic; We have to renew the OS-version on our conquest servers.
Our hospital supports the full (licensed) versions of MS SQL 2019 and 2022, so we prefer to use 2022. Is this version supported, and is there any experience using Conquest with this version/known issues/known special steps needed during installation of Conquest?
Thanks in advance for your answers!
-
Hi,
MSSQL requires uses an ODBC connection. As long as that works and standard SQL is supported, I see no reason why they would not work. I have not tried them though.
Marcel
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!