Viewing 15 posts - 20,041 through 20,055 (of 49,552 total)
satishm94 (2/28/2012)
1)What is the purpose of Msdb database? If you delete msdb database insatance is running or not?
I know the answer to that is in Books Online
2)Login cannot access? How...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 7:10 am
It's got nothing to do with procedures and nothing to do with parameters. The transaction log logs changes to database objects. So if an insert inserts 50kb of data, that's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 6:00 am
derekr 43208 (2/28/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 5:42 am
If you want to understand VAS, physical memory and the relationship, go find the videos by Mark Russinovich from CDC or TechEd. VAS pressure is more a 32-bit problem than...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 5:35 am
Sorry, I was thinking of the SSIS copy database task (which is not the same as the copy database wizard).
Use whatever you like, backup-restore is the usual method, it's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 5:30 am
64 bit?
If so, your calculation is about right, VAS is virtual address space, not physical memory and user VAS on 64 bit servers is 8 TB (iirc)
What are you trying...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 5:05 am
It does exist, there's a checkbox 'exclude rows that do not contain values' (as Gianluca mentioned)
If you check that, you may as well remove the batch completed and statement completed...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 5:01 am
rvasanth (2/28/2012)
I have measured the memory consumption with the Task Manager, 'Performance' tab.
Don't use task manager for monitoring SQL's memory, there are scenarios where it is completely and totally inaccurate....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 5:00 am
How are you monitoring memory usage?
You've checked and confirmed that the slowness is due to memory bottlenecks?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 4:42 am
Because profiler works the opposite way to SQL Server. In SQL Server a null value never matches a filter (unless it's IS NULL), in profiler a lack of a value...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 4:40 am
Joy Smith San (2/28/2012)
And in the log there will be entry for "execute proc procname(@var1 = 50KB string)", am I right ?
No. It's not an audit log, it's not an...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 4:34 am
I suspect this is blocking or latch wait-related. CXPacket would knock the CPU up as well as the duration.
Personally I'd leave MAXDOP alone without some significant analysis first.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 2:29 am
Check what Books Online says, there's a chance that the blog post is just wrong.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 2:24 am
satishm94 (2/27/2012)
i can use ssis for databse also , right? or is it not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2012 at 2:22 am
And specifically which perfmon counter? Can't help without enough details.
SQL doesn't store queries in memory. It stores data pages, it stores execution plans, not queries though.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2012 at 3:25 pm
Viewing 15 posts - 20,041 through 20,055 (of 49,552 total)