About sql server 2005
Hello
I am santosh using SQL Server 2005 on my server HP ML-350 G5 with 16 Gb Ram.I problem is facing that this server to take long processing time for the quarry .So we are shift this to another server which configuration is that 48 core
processor & 128 Gb Ram with Windows 2008 Enterprise 64 bit OS.But problem does not solved .to take long time processing the quarry .
Please help me to solve the my problem .
Santosh Thorwat ( IT Incharge)
Patil Group
Pune
Visit us :-www.patilgroup.co.in/www.patilconstruction.com
Email:edp@patilconstruction.com/edp.patilconstructions@gmail.com
February 26th, 2011 6:27am
What is your process (roughly) doing? I guess it's a SSIS process. Are your packages well designed? Poorly disigned packages can
dramaticly worsen the performance.
There are a lot of design/performance best practices available on the web. Here is a list of easy to implement
performance best practices.Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 6:50am
give us more materials!
did you tried a QUERY? a t-sql query?
or a SSIS package? how did you developed the package? or how did you wrote the query?
http://www.rad.pasfu.com
February 26th, 2011 11:52am
48 core processor and 128 gb ram is very good config.
It is mostly going to be your configuration settings for SQL or issues with codehttp://sqlworkday.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 5:55pm
48 core processor and 128 gb ram is very good config.
It is mostly going to be your configuration settings for SQL or issues with codehttp://sqlworkday.blogspot.com/
February 26th, 2011 5:55pm