Viewing 15 posts - 1 through 15 (of 116 total)
jabinc
i tried max server memory in sql server as 8 GB. still the memory increases over 11 gb and hangs
8gb is only the buffer pool memory, other memory is...
December 6, 2012 at 2:38 pm
jabinc (12/6/2012)
The server hangs once per day. after releasing the memory, the server works very well.while checking , we found that memory increases when there are lot of client connection
By...
December 6, 2012 at 2:31 pm
Is it the first time you are trying to connect or was it working fine earlier?
Pavan.
December 6, 2012 at 5:18 am
What other applications are running on that server?
Is it 32/64 bit?
Who is consuming most of the memory is it IIS or SQL Server?
Set the perfmon counters and see the memory...
December 6, 2012 at 5:12 am
SQL Guy 1 (11/29/2012)
It works fine in 99% of all ecxecutions. And there is no any pattern for failure timings, it looks completely random.
How much time does it take...
November 29, 2012 at 10:04 am
What is the data type of txtsupply and what are the actual values it holds?
If its a string then your destination column should also be string else integer!
Pavan.
November 29, 2012 at 9:50 am
Does it mean, it works fine sometimes and fails sometimes?
What does the ssis package do?
Pavan.
November 29, 2012 at 9:24 am
When you say the mail is in queue but has not been received, means it has left the server, but is blocked at the receiving end.
Check if the firewall team...
November 29, 2012 at 9:08 am
Check the below link
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI406
November 27, 2012 at 8:49 am
Why do you want to create the backup on a flat file, use SQL native backup tool and take the backup.
If you have to backup all tables on flat files,...
November 27, 2012 at 8:38 am
Is it a database or a table?
If table, you can use export / bcp to copy the contents of the table to a flat file.
Pavan
November 27, 2012 at 8:20 am
You dont have to, SQL does it automatically for you.
Pavan.
November 27, 2012 at 7:43 am
Since you say its during sort, this can be the case of spilling to tempdb as not enough memory was granted.
Check the estimated no. of rows and actual rows in...
November 27, 2012 at 7:41 am
Also, set statistics time and io on and get those results.
May be parameter sniffing issue!!!
July 18, 2012 at 4:19 am
The output is:
00A0903A-7F80-476A-95E5-5BF18FA67C19, 259979-64, FGW, 180, 14420, 1, D:\Shipping\FGW_20110704110000.trn, 2011-07-04 12:00:01.433, 2011-07-04 11:00:01.437, 5760
Just a quick note:
As I had...
July 4, 2011 at 5:42 am
Viewing 15 posts - 1 through 15 (of 116 total)