Viewing 15 posts - 766 through 780 (of 1,162 total)
Not really - there are some wait types that would be reduced by having more available memory, but the question is, so what?
Which instance needs more memory is more...
April 20, 2011 at 8:56 am
There's a blog post here that warns against holding large allocations of memory in CLR's as they'll get placed in the Large Object Heap which can be bad for performance:
http://blogs.msdn.com/b/sqlclrperf/archive/2007/06/01/scalable-memory-usage-in-sqlclr.aspx
I'd...
April 20, 2011 at 7:14 am
If this isn't a production server, could you also run the following (which clears the cumulative wait stats):
DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);
GO
Then run the CLR again and send the results of...
April 20, 2011 at 5:05 am
How many threads are you calling the procedure with?
The CLR Managed environment is designed to try to prevent poorly implemented code from taking down the server, so if you spawn...
April 20, 2011 at 3:58 am
Tomas Bergvall (4/20/2011)
April 20, 2011 at 1:47 am
I suspect that would only be the case if the server was under physical memory pressure. In reality, we've seen nothing of the OP's code and a unit test is...
April 19, 2011 at 12:00 pm
Sorry OPC, it really is 8TB and is on all 64-bit versions of SQL Server - MemtoLeave is simply irrelevant on a 64-bit version - unless it's been messed around...
April 19, 2011 at 10:47 am
No, it really is 8TB. VAS != available memory on the server.
64 bit systems can address 2^64 bytes of memory, but as this is hugely above any likely scale...
April 19, 2011 at 10:29 am
opc.three (4/19/2011)
Tomas Bergvall (4/19/2011)
I tried setting MemToLeave in increments without any difference in execution time. I even tried setting it to 2GB without noticing any performance gains.
In your earlier post...
April 19, 2011 at 10:13 am
Joseph Fallon (4/19/2011)
There is another DBA - I'm going to get my big stick and go a-hunting.
Happy hunting 😀
I can recommend Notepad++ -> Find All in Current Document as a...
April 19, 2011 at 7:42 am
ananda.murugesan (4/19/2011)
HowardW (4/19/2011)
What SQL Server version and compatibility mode are the two databases? The first query will only work on SQL 2005 + (and only in 90+ compatibility mode)
SQL server...
April 19, 2011 at 7:20 am
Happened on two other db's at the same time as well (each for a very short period):
Line 7417: 2011-04-18 16:12:51.38 spid101 Setting database option RECOVERY to...
April 19, 2011 at 7:00 am
From the logs:
2011-04-18 16:15:12.13 spid77 Setting database option RECOVERY to SIMPLE for database MyApp_LIVE_MPV.
2011-04-18 16:15:21.35 spid60 Setting database option RECOVERY...
April 19, 2011 at 6:28 am
What SQL Server version and compatibility mode are the two databases? The first query will only work on SQL 2005 + (and only in 90+ compatibility mode)
April 19, 2011 at 6:07 am
You could create an SSIS package to export the data to a flat file.
To call it from a stored procedure without requiring cmdshell, you could add it as a...
April 19, 2011 at 4:58 am
Viewing 15 posts - 766 through 780 (of 1,162 total)