Viewing 15 posts - 14,116 through 14,130 (of 19,562 total)
Tom.Thomson (5/8/2010)
French as first language doesn't often produce "s" for "ç"
I've seen them do it quite regularly. Especially since the "ç" makes an "s" sound.
May 9, 2010 at 7:25 am
Here is a similar issue that was resolved using DBCC CheckDB with Repair_Fast.
http://www.sqlservercentral.com/Forums/Topic374617-5-1.aspx#bm379178
May 8, 2010 at 6:28 pm
rambilla4 (5/7/2010)
You have a process that caused your tempdb to grow to a certain size. Once that process finished, the pages became free. Once a file grows, it will not...
May 7, 2010 at 6:21 pm
rambilla4 (5/7/2010)
I went through the link http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic5015.aspx
where the user Carolyn Godfrey stating the below:
Since tempdb does not require recovery, are there no automatic checkpoints
for tempdb except those when the...
May 7, 2010 at 4:41 pm
rambilla4 (5/7/2010)
Based on the last query you for which you provided results showing the allocation pages, it appears that checkpointing is occurring just fine. The pages are deallocated and...
May 7, 2010 at 4:38 pm
SELECT f1.[Checkpoint Begin], f2.[Checkpoint End]
FROM fn_dblog(NULL, NULL) f1
Inner Join fn_dblog(NULL, NULL) f2
On f1.[Current LSN] = f2.[Previous LSN]
WHERE f2.Operation IN (N'LOP_BEGIN_CKPT', N'LOP_END_CKPT');
May 7, 2010 at 4:03 pm
Lynn Pettis (5/7/2010)
CirquedeSQLeil (5/7/2010)
GilaMonster (5/7/2010)
May 7, 2010 at 4:00 pm
That measure is a bit out of whack. You only have a 2GB pagefile and 16GB of physical memory. The line graph is showing you the physical memory...
May 7, 2010 at 3:52 pm
Check out this discussion on the topic
http://www.sqlservercentral.com/Forums/Topic844628-149-1.aspx
May 7, 2010 at 3:43 pm
Based on the last query you for which you provided results showing the allocation pages, it appears that checkpointing is occurring just fine. The pages are deallocated and freed...
May 7, 2010 at 3:42 pm
dant12 (5/7/2010)
I mean a third-party application creating a new thread using the same sql server SPID
For example you have a SQL Server process running on SPID 25 and the third...
May 7, 2010 at 3:35 pm
Viewing 15 posts - 14,116 through 14,130 (of 19,562 total)