Mixing
Proper Guidelines for new Database setup in SQL Server [closed]
I need proper guidelines to setup Database in SQL Server for sales Application (Its a huge Data Transaction System). Specifically i'm looking below information:
- How to define
initial sizeto create Database - Should i use different
file and filegroups
- What type of
Collationshould i select - Any tips for
tempdbconfiguration - How to defined how much resource needed and how to allocate them.
- How to handle
Server Memory Setup(Minimum server memory, Maximum
server memory, Index creation memory, Minimum memory per query) - How to calculate/estimated number of Maximum
worker threads
- How to calculate/estimated Maximum number of
concurrent connections
- How to configure
SQL Server Parallelism(Cost Threshold for Parallelism, Locks, Max Degree, Query Wait)
Thanks in Advance
sql-server configuration
edited Jan 2 at 9:36
Shanky
14k32039
asked Jan 2 at 9:14
Md. Zakir HossainMd. Zakir Hossain
1113
closed as too broad by Erik Darling, Michael Green, Mr.Brownstone, Kris Gruttemeyer, mustaccio Jan 2 at 13:41
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I need proper guidelines to setup Database in SQL Server for sales Application (Its a huge Data Transaction System). Specifically i'm looking below information:
- How to define
initial sizeto create Database - Should i use different
file and filegroups
- What type of
Collationshould i select - Any tips for
tempdbconfiguration - How to defined how much resource needed and how to allocate them.
- How to handle
Server Memory Setup(Minimum server memory, Maximum
server memory, Index creation memory, Minimum memory per query) - How to calculate/estimated number of Maximum
worker threads
- How to calculate/estimated Maximum number of
concurrent connections
- How to configure
SQL Server Parallelism(Cost Threshold for Parallelism, Locks, Max Degree, Query Wait)
Thanks in Advance
sql-server configuration
edited Jan 2 at 9:36
Shanky
14k32039
asked Jan 2 at 9:14
Md. Zakir HossainMd. Zakir Hossain
1113
closed as too broad by Erik Darling, Michael Green, Mr.Brownstone, Kris Gruttemeyer, mustaccio Jan 2 at 13:41
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I need proper guidelines to setup Database in SQL Server for sales Application (Its a huge Data Transaction System). Specifically i'm looking below information:
- How to define
initial sizeto create Database - Should i use different
file and filegroups
- What type of
Collationshould i select - Any tips for
tempdbconfiguration - How to defined how much resource needed and how to allocate them.
- How to handle
Server Memory Setup(Minimum server memory, Maximum
server memory, Index creation memory, Minimum memory per query) - How to calculate/estimated number of Maximum
worker threads
- How to calculate/estimated Maximum number of
concurrent connections
- How to configure
SQL Server Parallelism(Cost Threshold for Parallelism, Locks, Max Degree, Query Wait)
Thanks in Advance
sql-server configuration
edited Jan 2 at 9:36
Shanky
14k32039
asked Jan 2 at 9:14
Md. Zakir HossainMd. Zakir Hossain
1113
I need proper guidelines to setup Database in SQL Server for sales Application (Its a huge Data Transaction System). Specifically i'm looking below information:
- How to define
initial sizeto create Database - Should i use different
file and filegroups
- What type of
Collationshould i select - Any tips for
tempdbconfiguration - How to defined how much resource needed and how to allocate them.
- How to handle
Server Memory Setup(Minimum server memory, Maximum
server memory, Index creation memory, Minimum memory per query) - How to calculate/estimated number of Maximum
worker threads
- How to calculate/estimated Maximum number of
concurrent connections
- How to configure
SQL Server Parallelism(Cost Threshold for Parallelism, Locks, Max Degree, Query Wait)
Thanks in Advance
sql-server configuration
sql-server configuration
edited Jan 2 at 9:36
Shanky
14k32039
asked Jan 2 at 9:14
Md. Zakir HossainMd. Zakir Hossain
1113
edited Jan 2 at 9:36
Shanky
14k32039
asked Jan 2 at 9:14
Md. Zakir HossainMd. Zakir Hossain
1113
edited Jan 2 at 9:36
Shanky
14k32039
edited Jan 2 at 9:36
Shanky
14k32039
edited Jan 2 at 9:36
Shanky
14k32039
14k32039
asked Jan 2 at 9:14
Md. Zakir HossainMd. Zakir Hossain
1113
asked Jan 2 at 9:14
Md. Zakir HossainMd. Zakir Hossain
1113
asked Jan 2 at 9:14
Md. Zakir HossainMd. Zakir Hossain
1113
1113
closed as too broad by Erik Darling, Michael Green, Mr.Brownstone, Kris Gruttemeyer, mustaccio Jan 2 at 13:41
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as too broad by Erik Darling, Michael Green, Mr.Brownstone, Kris Gruttemeyer, mustaccio Jan 2 at 13:41
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
How to define initial size to create Database
Well I believe you are asking what value to select for initial size ?. If so, I am sorry to say that it depends on your environment. But please do not leave it to default of 2 MB (for data file) and 1 MB (for log file). I wish MS had better value set as default but this is AFAIK from SQL Server 2005 and has not been changed yet. If you ask me, I would suggest to keep initial size to as much as possible to avoid autogrowth. Suppose you know your database would be 500 GB in year keep it to 300 GB and forget the hassle of autogrowth and slowness due to it, there is no harm in giving as much space to data file as it needs this is only going to benefit the queries. This size if for data file, for log file you would have to figure out yourself. SQL Server Database growth and Autogrowth Setting article would help you more.
Should i use different file and filegroups
Well again the answer is "it depends", file and filegroups are more for making DBA's management job easier and segregating things. If you have large database where you want to offload non critical objects which are accessed less on slow drive and move more accessed objects on faster drive you can do it via filegroups. You can also move one BIG table to altogether different filegroup residing on fast drive to make queries faster. Please read below 2 discussions.
- Benefit to use multiple filegroups
- Benefit of filegroups and setting filegroups to read-only
What type of Collation should i select
That definitely I cannot tell and you should ask the respective teams.
Any tips for tempdb configuration
A lot, please refer to below links. Since you have not added what version of SQL Server you are talking I would only suggest very basic things. Putting tempdb on faster drive makes queries using temp tables fast. Make sure you correctly add temdb data files and keep initial size and autogrowth same for all the data files. For SQL Server 2014 and before enabling TF 1117 and 1118 is also recommended. For SQL Server 2016 and above TF's are not required. More details Here
- Correctly adding Tempdb Files
- Cheat Sheet How to Configure Tempdb
How to defined how much resource needed and how to allocate them
That needs lot of information from your side. There is no direct formula for it.
How to handle Server Memory Setup (Minimum server memory, Maximum server memory, Index creation memory, Minimum memory per query)
To configure max server memory please refer What is a deterministic method for evaluating a sensible buffer pool size?. Don't touch index creation memory and minimum memory per query. If you are having just one instance of SQL server leave min server memory to default.
Ignore points 7 should not touch those settings unless you are expert. The default just works fine. You should let SQL Server decide worker threads it does the job beautifully.
How to calculate/estimated Maximum number of concurrent connections
Unless you start putting some load on server there is hardly any point in getting concurrent connection. For getting max connections on SQL Server hitting see Stackexchange thread Max Number of connection
How to configure SQL Server Parallelism (Cost Threshold for Parallelism, Locks, Max Degree, Query Wait)
You just need to setup proper max degree of parallelism rest you should leave to default. For maxdop setting refer MAXDOP setting algorithm for SQL Server
answered Jan 2 at 10:00
ShankyShanky
14k32039
thanks. Could you please suggest me any article for Question No-5
– Md. Zakir Hossain
Jan 2 at 10:47
You need to be more clear about what resources you are talking about. There is no rule you would have to start by your own. How big is your application, how many users would be accessing it, what would be size of database ?.
– Shanky
Jan 2 at 10:55
User : 300-350; Database size would be 5-7 GB after one year. 1. In this case how to estimate minimum requirement of RAM and Processor for Database Server? 2.Suppose I've some backend process which running on SQL Server. I want to allocate 25% of RAM/CPU for backend process and rest 75% resource for Normal Transaction through my application. Is it possible?
– Md. Zakir Hossain
Jan 2 at 11:29
For above you may start with 4 core CPU and 8 GB RAM. This is PURELY out of guess. You can limit CPU and memory to some extent using Resource Governor which is ONLY there in enterprise editions of SQL Server
– Shanky
Jan 2 at 11:37
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
How to define initial size to create Database
Well I believe you are asking what value to select for initial size ?. If so, I am sorry to say that it depends on your environment. But please do not leave it to default of 2 MB (for data file) and 1 MB (for log file). I wish MS had better value set as default but this is AFAIK from SQL Server 2005 and has not been changed yet. If you ask me, I would suggest to keep initial size to as much as possible to avoid autogrowth. Suppose you know your database would be 500 GB in year keep it to 300 GB and forget the hassle of autogrowth and slowness due to it, there is no harm in giving as much space to data file as it needs this is only going to benefit the queries. This size if for data file, for log file you would have to figure out yourself. SQL Server Database growth and Autogrowth Setting article would help you more.
Should i use different file and filegroups
Well again the answer is "it depends", file and filegroups are more for making DBA's management job easier and segregating things. If you have large database where you want to offload non critical objects which are accessed less on slow drive and move more accessed objects on faster drive you can do it via filegroups. You can also move one BIG table to altogether different filegroup residing on fast drive to make queries faster. Please read below 2 discussions.
- Benefit to use multiple filegroups
- Benefit of filegroups and setting filegroups to read-only
What type of Collation should i select
That definitely I cannot tell and you should ask the respective teams.
Any tips for tempdb configuration
A lot, please refer to below links. Since you have not added what version of SQL Server you are talking I would only suggest very basic things. Putting tempdb on faster drive makes queries using temp tables fast. Make sure you correctly add temdb data files and keep initial size and autogrowth same for all the data files. For SQL Server 2014 and before enabling TF 1117 and 1118 is also recommended. For SQL Server 2016 and above TF's are not required. More details Here
- Correctly adding Tempdb Files
- Cheat Sheet How to Configure Tempdb
How to defined how much resource needed and how to allocate them
That needs lot of information from your side. There is no direct formula for it.
How to handle Server Memory Setup (Minimum server memory, Maximum server memory, Index creation memory, Minimum memory per query)
To configure max server memory please refer What is a deterministic method for evaluating a sensible buffer pool size?. Don't touch index creation memory and minimum memory per query. If you are having just one instance of SQL server leave min server memory to default.
Ignore points 7 should not touch those settings unless you are expert. The default just works fine. You should let SQL Server decide worker threads it does the job beautifully.
How to calculate/estimated Maximum number of concurrent connections
Unless you start putting some load on server there is hardly any point in getting concurrent connection. For getting max connections on SQL Server hitting see Stackexchange thread Max Number of connection
How to configure SQL Server Parallelism (Cost Threshold for Parallelism, Locks, Max Degree, Query Wait)
You just need to setup proper max degree of parallelism rest you should leave to default. For maxdop setting refer MAXDOP setting algorithm for SQL Server
answered Jan 2 at 10:00
ShankyShanky
14k32039
thanks. Could you please suggest me any article for Question No-5
– Md. Zakir Hossain
Jan 2 at 10:47
You need to be more clear about what resources you are talking about. There is no rule you would have to start by your own. How big is your application, how many users would be accessing it, what would be size of database ?.
– Shanky
Jan 2 at 10:55
User : 300-350; Database size would be 5-7 GB after one year. 1. In this case how to estimate minimum requirement of RAM and Processor for Database Server? 2.Suppose I've some backend process which running on SQL Server. I want to allocate 25% of RAM/CPU for backend process and rest 75% resource for Normal Transaction through my application. Is it possible?
– Md. Zakir Hossain
Jan 2 at 11:29
For above you may start with 4 core CPU and 8 GB RAM. This is PURELY out of guess. You can limit CPU and memory to some extent using Resource Governor which is ONLY there in enterprise editions of SQL Server
– Shanky
Jan 2 at 11:37
add a comment |
How to define initial size to create Database
Well I believe you are asking what value to select for initial size ?. If so, I am sorry to say that it depends on your environment. But please do not leave it to default of 2 MB (for data file) and 1 MB (for log file). I wish MS had better value set as default but this is AFAIK from SQL Server 2005 and has not been changed yet. If you ask me, I would suggest to keep initial size to as much as possible to avoid autogrowth. Suppose you know your database would be 500 GB in year keep it to 300 GB and forget the hassle of autogrowth and slowness due to it, there is no harm in giving as much space to data file as it needs this is only going to benefit the queries. This size if for data file, for log file you would have to figure out yourself. SQL Server Database growth and Autogrowth Setting article would help you more.
Should i use different file and filegroups
Well again the answer is "it depends", file and filegroups are more for making DBA's management job easier and segregating things. If you have large database where you want to offload non critical objects which are accessed less on slow drive and move more accessed objects on faster drive you can do it via filegroups. You can also move one BIG table to altogether different filegroup residing on fast drive to make queries faster. Please read below 2 discussions.
- Benefit to use multiple filegroups
- Benefit of filegroups and setting filegroups to read-only
What type of Collation should i select
That definitely I cannot tell and you should ask the respective teams.
Any tips for tempdb configuration
A lot, please refer to below links. Since you have not added what version of SQL Server you are talking I would only suggest very basic things. Putting tempdb on faster drive makes queries using temp tables fast. Make sure you correctly add temdb data files and keep initial size and autogrowth same for all the data files. For SQL Server 2014 and before enabling TF 1117 and 1118 is also recommended. For SQL Server 2016 and above TF's are not required. More details Here
- Correctly adding Tempdb Files
- Cheat Sheet How to Configure Tempdb
How to defined how much resource needed and how to allocate them
That needs lot of information from your side. There is no direct formula for it.
How to handle Server Memory Setup (Minimum server memory, Maximum server memory, Index creation memory, Minimum memory per query)
To configure max server memory please refer What is a deterministic method for evaluating a sensible buffer pool size?. Don't touch index creation memory and minimum memory per query. If you are having just one instance of SQL server leave min server memory to default.
Ignore points 7 should not touch those settings unless you are expert. The default just works fine. You should let SQL Server decide worker threads it does the job beautifully.
How to calculate/estimated Maximum number of concurrent connections
Unless you start putting some load on server there is hardly any point in getting concurrent connection. For getting max connections on SQL Server hitting see Stackexchange thread Max Number of connection
How to configure SQL Server Parallelism (Cost Threshold for Parallelism, Locks, Max Degree, Query Wait)
You just need to setup proper max degree of parallelism rest you should leave to default. For maxdop setting refer MAXDOP setting algorithm for SQL Server
answered Jan 2 at 10:00
ShankyShanky
14k32039
thanks. Could you please suggest me any article for Question No-5
– Md. Zakir Hossain
Jan 2 at 10:47
You need to be more clear about what resources you are talking about. There is no rule you would have to start by your own. How big is your application, how many users would be accessing it, what would be size of database ?.
– Shanky
Jan 2 at 10:55
User : 300-350; Database size would be 5-7 GB after one year. 1. In this case how to estimate minimum requirement of RAM and Processor for Database Server? 2.Suppose I've some backend process which running on SQL Server. I want to allocate 25% of RAM/CPU for backend process and rest 75% resource for Normal Transaction through my application. Is it possible?
– Md. Zakir Hossain
Jan 2 at 11:29
For above you may start with 4 core CPU and 8 GB RAM. This is PURELY out of guess. You can limit CPU and memory to some extent using Resource Governor which is ONLY there in enterprise editions of SQL Server
– Shanky
Jan 2 at 11:37
add a comment |
How to define initial size to create Database
Well I believe you are asking what value to select for initial size ?. If so, I am sorry to say that it depends on your environment. But please do not leave it to default of 2 MB (for data file) and 1 MB (for log file). I wish MS had better value set as default but this is AFAIK from SQL Server 2005 and has not been changed yet. If you ask me, I would suggest to keep initial size to as much as possible to avoid autogrowth. Suppose you know your database would be 500 GB in year keep it to 300 GB and forget the hassle of autogrowth and slowness due to it, there is no harm in giving as much space to data file as it needs this is only going to benefit the queries. This size if for data file, for log file you would have to figure out yourself. SQL Server Database growth and Autogrowth Setting article would help you more.
Should i use different file and filegroups
Well again the answer is "it depends", file and filegroups are more for making DBA's management job easier and segregating things. If you have large database where you want to offload non critical objects which are accessed less on slow drive and move more accessed objects on faster drive you can do it via filegroups. You can also move one BIG table to altogether different filegroup residing on fast drive to make queries faster. Please read below 2 discussions.
- Benefit to use multiple filegroups
- Benefit of filegroups and setting filegroups to read-only
What type of Collation should i select
That definitely I cannot tell and you should ask the respective teams.
Any tips for tempdb configuration
A lot, please refer to below links. Since you have not added what version of SQL Server you are talking I would only suggest very basic things. Putting tempdb on faster drive makes queries using temp tables fast. Make sure you correctly add temdb data files and keep initial size and autogrowth same for all the data files. For SQL Server 2014 and before enabling TF 1117 and 1118 is also recommended. For SQL Server 2016 and above TF's are not required. More details Here
- Correctly adding Tempdb Files
- Cheat Sheet How to Configure Tempdb
How to defined how much resource needed and how to allocate them
That needs lot of information from your side. There is no direct formula for it.
How to handle Server Memory Setup (Minimum server memory, Maximum server memory, Index creation memory, Minimum memory per query)
To configure max server memory please refer What is a deterministic method for evaluating a sensible buffer pool size?. Don't touch index creation memory and minimum memory per query. If you are having just one instance of SQL server leave min server memory to default.
Ignore points 7 should not touch those settings unless you are expert. The default just works fine. You should let SQL Server decide worker threads it does the job beautifully.
How to calculate/estimated Maximum number of concurrent connections
Unless you start putting some load on server there is hardly any point in getting concurrent connection. For getting max connections on SQL Server hitting see Stackexchange thread Max Number of connection
How to configure SQL Server Parallelism (Cost Threshold for Parallelism, Locks, Max Degree, Query Wait)
You just need to setup proper max degree of parallelism rest you should leave to default. For maxdop setting refer MAXDOP setting algorithm for SQL Server
answered Jan 2 at 10:00
ShankyShanky
14k32039
How to define initial size to create Database
Well I believe you are asking what value to select for initial size ?. If so, I am sorry to say that it depends on your environment. But please do not leave it to default of 2 MB (for data file) and 1 MB (for log file). I wish MS had better value set as default but this is AFAIK from SQL Server 2005 and has not been changed yet. If you ask me, I would suggest to keep initial size to as much as possible to avoid autogrowth. Suppose you know your database would be 500 GB in year keep it to 300 GB and forget the hassle of autogrowth and slowness due to it, there is no harm in giving as much space to data file as it needs this is only going to benefit the queries. This size if for data file, for log file you would have to figure out yourself. SQL Server Database growth and Autogrowth Setting article would help you more.
Should i use different file and filegroups
Well again the answer is "it depends", file and filegroups are more for making DBA's management job easier and segregating things. If you have large database where you want to offload non critical objects which are accessed less on slow drive and move more accessed objects on faster drive you can do it via filegroups. You can also move one BIG table to altogether different filegroup residing on fast drive to make queries faster. Please read below 2 discussions.
- Benefit to use multiple filegroups
- Benefit of filegroups and setting filegroups to read-only
What type of Collation should i select
That definitely I cannot tell and you should ask the respective teams.
Any tips for tempdb configuration
A lot, please refer to below links. Since you have not added what version of SQL Server you are talking I would only suggest very basic things. Putting tempdb on faster drive makes queries using temp tables fast. Make sure you correctly add temdb data files and keep initial size and autogrowth same for all the data files. For SQL Server 2014 and before enabling TF 1117 and 1118 is also recommended. For SQL Server 2016 and above TF's are not required. More details Here
- Correctly adding Tempdb Files
- Cheat Sheet How to Configure Tempdb
How to defined how much resource needed and how to allocate them
That needs lot of information from your side. There is no direct formula for it.
How to handle Server Memory Setup (Minimum server memory, Maximum server memory, Index creation memory, Minimum memory per query)
To configure max server memory please refer What is a deterministic method for evaluating a sensible buffer pool size?. Don't touch index creation memory and minimum memory per query. If you are having just one instance of SQL server leave min server memory to default.
Ignore points 7 should not touch those settings unless you are expert. The default just works fine. You should let SQL Server decide worker threads it does the job beautifully.
How to calculate/estimated Maximum number of concurrent connections
Unless you start putting some load on server there is hardly any point in getting concurrent connection. For getting max connections on SQL Server hitting see Stackexchange thread Max Number of connection
How to configure SQL Server Parallelism (Cost Threshold for Parallelism, Locks, Max Degree, Query Wait)
You just need to setup proper max degree of parallelism rest you should leave to default. For maxdop setting refer MAXDOP setting algorithm for SQL Server
answered Jan 2 at 10:00
ShankyShanky
14k32039
edited Jan 2 at 10:33
answered Jan 2 at 10:00
ShankyShanky
14k32039
answered Jan 2 at 10:00
ShankyShanky
14k32039
answered Jan 2 at 10:00
ShankyShanky
14k32039
14k32039
thanks. Could you please suggest me any article for Question No-5
– Md. Zakir Hossain
Jan 2 at 10:47
You need to be more clear about what resources you are talking about. There is no rule you would have to start by your own. How big is your application, how many users would be accessing it, what would be size of database ?.
– Shanky
Jan 2 at 10:55
User : 300-350; Database size would be 5-7 GB after one year. 1. In this case how to estimate minimum requirement of RAM and Processor for Database Server? 2.Suppose I've some backend process which running on SQL Server. I want to allocate 25% of RAM/CPU for backend process and rest 75% resource for Normal Transaction through my application. Is it possible?
– Md. Zakir Hossain
Jan 2 at 11:29
For above you may start with 4 core CPU and 8 GB RAM. This is PURELY out of guess. You can limit CPU and memory to some extent using Resource Governor which is ONLY there in enterprise editions of SQL Server
– Shanky
Jan 2 at 11:37
add a comment |
thanks. Could you please suggest me any article for Question No-5
– Md. Zakir Hossain
Jan 2 at 10:47
You need to be more clear about what resources you are talking about. There is no rule you would have to start by your own. How big is your application, how many users would be accessing it, what would be size of database ?.
– Shanky
Jan 2 at 10:55
User : 300-350; Database size would be 5-7 GB after one year. 1. In this case how to estimate minimum requirement of RAM and Processor for Database Server? 2.Suppose I've some backend process which running on SQL Server. I want to allocate 25% of RAM/CPU for backend process and rest 75% resource for Normal Transaction through my application. Is it possible?
– Md. Zakir Hossain
Jan 2 at 11:29
For above you may start with 4 core CPU and 8 GB RAM. This is PURELY out of guess. You can limit CPU and memory to some extent using Resource Governor which is ONLY there in enterprise editions of SQL Server
– Shanky
Jan 2 at 11:37
thanks. Could you please suggest me any article for Question No-5
– Md. Zakir Hossain
Jan 2 at 10:47
thanks. Could you please suggest me any article for Question No-5
– Md. Zakir Hossain
Jan 2 at 10:47
You need to be more clear about what resources you are talking about. There is no rule you would have to start by your own. How big is your application, how many users would be accessing it, what would be size of database ?.
– Shanky
Jan 2 at 10:55
You need to be more clear about what resources you are talking about. There is no rule you would have to start by your own. How big is your application, how many users would be accessing it, what would be size of database ?.
– Shanky
Jan 2 at 10:55
User : 300-350; Database size would be 5-7 GB after one year. 1. In this case how to estimate minimum requirement of RAM and Processor for Database Server? 2.Suppose I've some backend process which running on SQL Server. I want to allocate 25% of RAM/CPU for backend process and rest 75% resource for Normal Transaction through my application. Is it possible?
– Md. Zakir Hossain
Jan 2 at 11:29
User : 300-350; Database size would be 5-7 GB after one year. 1. In this case how to estimate minimum requirement of RAM and Processor for Database Server? 2.Suppose I've some backend process which running on SQL Server. I want to allocate 25% of RAM/CPU for backend process and rest 75% resource for Normal Transaction through my application. Is it possible?
– Md. Zakir Hossain
Jan 2 at 11:29
For above you may start with 4 core CPU and 8 GB RAM. This is PURELY out of guess. You can limit CPU and memory to some extent using Resource Governor which is ONLY there in enterprise editions of SQL Server
– Shanky
Jan 2 at 11:37
For above you may start with 4 core CPU and 8 GB RAM. This is PURELY out of guess. You can limit CPU and memory to some extent using Resource Governor which is ONLY there in enterprise editions of SQL Server
– Shanky
Jan 2 at 11:37
add a comment |
