Viewing 15 posts - 166 through 180 (of 956 total)
sqlnsg (1/8/2010)
The following is the Disk Configaration , Its a local SAN IBM DS 4800 (4 TB) connected through Fiber Channel dual port HBA cards . Its not dedicated san...
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 6:42 pm
Uma-419424 (1/8/2010)
Simply give execute permission on the sp "sp_send_dbmail" to the role "public" in the database "msdb".
That would violate Audit rules at my company, and most publicly held companies as...
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 5:37 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
Is this a Virtual Machine? I don't know...
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 5:28 pm
The_SQL_DBA (1/8/2010)
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..
As a matter of practice this...
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 5:25 pm
Krasavita (1/8/2010)
Target Server Memory (KB) 819200
Total Server Memory (KB) ...
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 5:23 pm
CirquedeSQLeil (1/8/2010)
Krasavita (1/8/2010)
I don't expect production to run queries developed in dev with parallelism. Can main instanse be disable...
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:53 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,...
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:19 am
Krasavita (1/8/2010)
SQLServer:Memory Manager Target Server Memory (KB) ...
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 10:04 am
Greg Edwards-268690 (1/8/2010)
At a bare minimum, 9 * 1GB for the instances + 2 GB for the OS.
And each...
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 9:58 am
Krasavita (1/8/2010)
I know max 2147483647 MB, for each instanse, how much should I cut down too?
How much memory does the physical server have and is it x86 or x64?
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 9:14 am
Krasavita (1/8/2010)
How can I see in sql server all instanses?This is what I have from your code,but it is not showing instanse name:
Either use PerfMon and add the counters for...
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 7:55 am
Lynn Pettis (1/5/2010)
What is the configuration of the development server (total server memory, disk drives (raid type or not, etc)? How are the instances configured (min/max memory, etc)?
The information...
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 5, 2010 at 2:28 pm
Krasavita (1/5/2010)
Is there any documentations that I can find out on that. What should I run to see how much memory used for all instanses.Thank you
Which specific part are you...
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 5, 2010 at 2:07 pm
I'd start by checking the permissions assigned to the SQL Agent Service Account.
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 5, 2010 at 10:33 am
Krasavita (1/5/2010)
I have 9 instances for my dev enviroment and we are having performance problems(very slow)Can you please provide me the requirements,what you need to do for the...
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 5, 2010 at 10:24 am
Viewing 15 posts - 166 through 180 (of 956 total)