January 8, 2010 at 11:19 am
Krasavita (1/8/2010)
This is development server, I recommended to switch to 64 bit how many processors I need?
Its hard to tell without knowing the workload. Processors are cheap these days, its not expensive to pick up a quad core server, or at least if your budget allows it. I wouldn't run more than 1 instance per processor core personally, but it depends on a number of factors like database size, transaction workload you expect in development, do you expect your production environment to run queries developed in dev with parallelism?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 8, 2010 at 11:38 am
Krasavita (1/8/2010)
Oh, I didn't change max memory for my maine instanse, do I need it? I only changed max memory for all 9 instansases
Yes, you will need to change the settings for the default instance as well. For the 9 instances, those would be named instances. The total number of instances you have is 10 (which could change some of the posts in this thread for recommended settings).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2010 at 11:42 am
Krasavita (1/8/2010)
I stoped 4 instances that we are not using and changex max settings and now I have these:counter_nameinstance_namecntr_value
Target Server Memory (KB) 1497560
Total Server Memory (KB) 22784
Thank you very much for your help
This is development server, I recommended to switch to 64 bit how many processors I need?
If you are not using the instance, is there good reason to keep it installed?
It looks like the instance you are looking at is still only getting 22MB addressed to it - you will continue to have performance issues if that persists.
HOW MANY TOTAL GIGS OF RAM are installed physically into the server?
How many procs do you need? Well, that is a recommendation and not something we could fully assess without more information. Load and budget play factors in that assessment. As far as a recommendation though - between 8 and 16 procs would be fantastic for a dev box IMO.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2010 at 11:43 am
Do I need to re boot after I changed max memory settings?
I don't expect production to run queries developed in dev with parallelism. Can main instanse be disable and all others running sessesfully?
January 8, 2010 at 11:45 am
Krasavita (1/8/2010)
Do I need to re boot after I changed max memory settings?I don't expect production to run queries developed in dev with parallelism. Can main instanse be disable and all others running sessesfully?
You need to restart the services, but a reboot is not mandatory.
Default instance can be disabled and still permit the named instances to continue to run successfully.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2010 at 11:47 am
You need how many CPUs you need. Depends on load, and the performance you need from them.
January 8, 2010 at 11:53 am
CirquedeSQLeil (1/8/2010)
Krasavita (1/8/2010)
Do I need to re boot after I changed max memory settings?I don't expect production to run queries developed in dev with parallelism. Can main instanse be disable and all others running sessesfully?
You need to restart the services, but a reboot is not mandatory.
Default instance can be disabled and still permit the named instances to continue to run successfully.
Max Server Memory settings take effect immediately. No restart is required.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 8, 2010 at 1:08 pm
We installed 1 more processor,but it is not showing that we have 2 now,what do we need to do Thank you
January 8, 2010 at 1:11 pm
Krasavita (1/8/2010)
We installed 1 more processor,but it is not showing that we have 2 now,what do we need to do Thank you
Does the OS show that you have an additional processor?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2010 at 1:26 pm
You can shut down the services for the two unneeded instances in the Control Panel | Servers, and set their startup to "manual".
I am not sure if I shut down services properly,
I have:
SQLSErverAgent instansances,SQL Server Agent,SQL Sever FullText, where I stop services for instances I don't want to use? I don't see processor when I go tot he properties of instanse. Thank you
January 8, 2010 at 1:31 pm
type services.msc in start-->run and locate the service name for the instance you want to stop. It should be something like devsvr\sql01, devsvr\sql02.
Thanks..
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2010 at 2:30 pm
Thank you everyone for your help,
Question what should I look for and how that I would have enough memory on my instanse.
January 8, 2010 at 2:39 pm
I am not sure I follow your question.
Could you elaborate please?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2010 at 2:40 pm
counter_nameinstance_namecntr_value
Target Server Memory (KB) 819200
Total Server Memory (KB) 444160 this is one of my instance
January 8, 2010 at 2:43 pm
How to check if I have enough memory on a instanse
Viewing 15 posts - 31 through 45 (of 55 total)
You must be logged in to reply to this topic. Login to reply