Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Character set, CPU, and memory
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2014
Application:
Web
Divers
Thread ID:
01618215
Message ID:
01618223
Vues:
38
>>A DBA asked me (in email) what are the "character set, CPU, and memory" requirements for SQL Server for my VFP 9 application. I need help in replying and sounding professional :).
>>1 Usually when I install SQL Server Express on customers' servers (where they don't have a DBA) I leave all defaults. Which means, what "character set" am I using?
>>2 I never specify CPU because the VM servers customers built is sufficient for running SQL Server 2008 Express. What should I indicate as a minimum CPU?
>>3 SQL Server Express uses only 1GB of RAM on the server. Would it be correct to say that "1GB of RAM is the memory requirement"?
>>
>>TIA
>
>Hi Dmitry,
>
>1) https://msdn.microsoft.com/en-us/library/ms175194.aspx
>To maintain compatibility with earlier versions of SQL Server, or applications that were developed with SQL Server collations in earlier versions of SQL Server, SQL Server offers the SQL_Latin1_General_CP1_CI_AS collation as the default collation for server installations on computers that use the English (United States) Windows system locale.
>
>2) For SQL Express you don't need specify CPU, because it's SQL Express - but you can write dual core (second core for next instance)
>
>3) SQL Express cannot use more than 1GiB Ram - the limit is 1 GiB Ram (for instance).
>
>MartinaJ

Thank you, Martina. This is very helpful.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform