Viewing 15 posts - 466 through 480 (of 859 total)
For sql 2000 run this query
select * from
sys.sysperfinfo
Where counter_name
in('Target Server Memory (KB)','Total Server Memory (KB)')
Check the following Counters in perfmon.msc.
1.Memory: Pages/sec
Average between 0 and 20
2.Memory: Available...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
May 12, 2011 at 5:03 am
OS verison pls.
Did you grant the lock pages memory to the sql account.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
May 12, 2011 at 5:02 am
harsha.bhagat1 (5/12/2011)
2. There was a differential backup taken yesterday night and I took one more differential backup on the same device.
Have you checked the filelistonly ? How many files are...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
May 12, 2011 at 4:55 am
sql2k8 (5/10/2011)
I have SQL Server 2008 R2 enterprise edition.on windows server 2008 enterprise 64 bit
I did the same in my environment but i don't have the script right now.
You may...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
May 12, 2011 at 4:48 am
http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
May 12, 2011 at 4:30 am
usharani.t (4/21/2011)
Thanks For Your Reply......
I think for three members you replied 3-Times thanks 🙂
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
April 21, 2011 at 6:07 am
kvr1985 (4/18/2011)
Hi All,when we do any operation or transaction all are logged into log buffer.when you run the checkpoint save the all data to main database.
Couldn't understand the question?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
April 18, 2011 at 5:25 am
annasql (4/10/2011)
I checked this is a window 2003, 32 bits, 2 gb memory.The memory setup uses the default of sql server.
Thanks
Your box have only 2 GB ram?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
April 11, 2011 at 1:36 am
Sachin Nandanwar (3/27/2011)
But what happens if a checkpoint occurs in middle of a very long running transaction and then the transaction rolls back.
The dirty pages now have been written...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 28, 2011 at 4:19 am
Write data pages to disk != remove pages from memory.
excellent gail.
opening ssc now only (on monday morning)
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 28, 2011 at 3:50 am
Read the Gail's article Why is my transaction log full?[/url]
This too
http://www.sqlservercentral.com/articles/64582/
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 27, 2011 at 3:15 am
GilaMonster (3/23/2011)
muthukkumaran (3/23/2011)
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 23, 2011 at 9:36 am
Patricia Johnson (3/22/2011)
Your website link said to defrag indexes based on these conditions:
1. Fragmentation >30 AND PAGES>1000 then rebuild
2. Fragmentation between 15 to 30 AND PAGES>1000 then reorganize&updatestatistics
3....
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 23, 2011 at 3:23 am
Sachin Nandanwar (3/22/2011)
Brandie Tarvin (3/22/2011)
A checkpoint doesn't change the size of the log files. It just marks a section of the log as ready to be reused by the transaction...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 23, 2011 at 2:55 am
Thanks Ninja's_RGR'us.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 22, 2011 at 6:06 am
Viewing 15 posts - 466 through 480 (of 859 total)