Viewing 15 posts - 466 through 480 (of 860 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...
May 12, 2011 at 5:03 am
OS verison pls.
Did you grant the lock pages memory to the sql account.
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...
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...
May 12, 2011 at 4:48 am
vamshi.sql (4/20/2011)
Can anyone please let me know the query to rebuild all the indexes in an SQL Server 2000 Database??
I need to rebuild all the indexes in database at...
April 21, 2011 at 6:17 am
usharani.t (4/21/2011)
Thanks For Your Reply......
I think for three members you replied 3-Times thanks 🙂
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?
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?
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...
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)
March 28, 2011 at 3:50 am
March 27, 2011 at 3:15 am
GilaMonster (3/23/2011)
muthukkumaran (3/23/2011)
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....
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...
March 23, 2011 at 2:55 am
Viewing 15 posts - 466 through 480 (of 860 total)