Answered by:. Archived Forums. Sign in to vote. Hi Guys, for the last 4 hours i was binging my head against the wall trying to find a right configuration for my Tempdb database anf finally i used BPA and i had a good clue which is I have to find out how many SQL OS schedulers are currently online and then configure multiple tempdb files that can support the concurrent activity on these schedulers.
Tuesday, September 13, PM. Searching and finding a string value in all columns in a SQL Server table. View all my tips. Back To Top That makes my day. Thanks for this. Hope you know how much your blog helps others! Pinky, Can you post the code that creates the temp table? This tip comes courtesy of reader John Langston. You can make changes to that database, and those changes will automatically happen to any new databases.
John writes:. For example, they may decide to use Database Mail to send out mass emails to your end users or customers. At our shops, we use internal emails like servername ourcompany. Those email addresses make sense to us because we just need to know where the alerts are coming from — we would never hit Reply to a server-generated email. However, if developers use SQL Server to send out emails directly to customers, those customers will indeed reply. Please contact us for questions.
After some confusion, we were able to track down the guilty party, but those emails never should have gone out from the IT staff. Bottom line: if you decide to use Database Mail and you should , consider setting up separate private and public email profiles.
These include running out of space in log files, backup failures, failed logins and other things DBAs just need to be aware of. The below script will set up an alert for severity This is where things start to get different on a shop-by-shop basis. Some places use native backups, some places use backup compression software, some places use index defrag software, and so on.
Before it goes live, this is your one chance to really bang the daylights out of it without anybody complaining. They give you a prioritized list of health and performance issues, plus gives you URLs for more details about each issue.
Check the error logs. Windows and SQL. I tell all my dbas to save and empty the log before install and then again when they are complete and attach those files to the as built doco. Yeah, that bit about AWE is a bogus statement without documentation.
Also, we set the max and min memory for SQL. Scott — good catch! Better to update one page than a bunch! I figured it was, as some perfmon stats seemed to show 30Gb of memory eventually being committed, but am confused by two things:. Is Task Mgr PF Usage really talking about virtual memory, or is it including physical memory as well? I hope you can shed some light here, my interweb searching has mostly shown up more people wondering similar things without resolution.
Yeah, something doesn't add up there — if you go into Control Panel, System, on the General tab, what's it show for memory? It's in the "Computer" section at the bottom. Can you email me a screenshot? Task Mgr is a confusing place to be.
Don't take its claims about page file usage literally; the stats are very useful but the way they're presented misleading. In the section regarding configuring memory, the image shows that you have the Min and Max set to the same amount. Is this the recommended best practice?
Like with everything else in SQL, the answer is that it depends. For servers that only have SQL Server running on them and nothing else, this is how I usually configure memory. The OS is seeing 32Gb. SQL Server memory set to 24Gb. Great point! Brent, the comment about enable the AWE option even on 64bit servers is wrong. I have a question about placement of the tempdb. I have a question regarding the tempdb files and the Max Degree of parallelism.
Hi, Panco. Like everything else in SQL Server, the answer is — it depends. Hope that helps! Thank you for this excellent article.
See the below email from our network guy, who setup the VM server :. The server has 3 drives, just for conformity purposes, c: D: — databases E: — Logs. As it is a VM it does not have physical drives, so splitting logs, data and the os drives makes no performance difference as the virtual disks runs on the same physical hardware anyway. Do you agree with his comments? Secondly, is it ok to leave the system DBs on C drive or what is the best practise regard to the systems DBs?
By default they are always saved on C drive. How to move them? I have done some research but I could find answers. Would it be possible to email performance dashboard reports on a scheduled basis from the same instance? One thing I was hoping to find in either this post or the previous one, was a discussion about granting rights to DBAs.
Is that too much or too little? Unfortunately, this is a huge discussion in and of itself. Hope that helps though! We just have the possibility to split the installation on two disks, one of them running the system Windows Server R2. Use it a lot, concise good advice and not too much overload on the techy jargon. Been a DBA for a long time, simple is good. Like Panco above, I was curious about the no. We shall see. That means you would just need 2 to 4 TempDB data files. About whether to use shared or dedicated disks, read these posts:.
Do you have any links? All with the mdf, all with the ldf, or should I split it? David — thanks, glad you liked the book. It all depends on the amount of user database reads, writes, and TempDB load. You need to strike a balance for your needs.
Does anyone know how to add extra accounts to the SQL Administrators group on a cluster install?? I added the 3 current DBA domain accounts during the install on the DB Engine Configuration screen but now need to add a new starters account. Where can I do this?? I just want to say my heartily thanks to you, for your valuable contribution for SQL Server.
The best part is that you are sharing your hard earned knowledge with everyone and everyone is get benefited by this. Simply I will pray to GOD to give you long life and send people like you on this earth.
I pray to GOD to make your all good desired come true. Just keep it up and we also like to share our knowledge with you, if it make some value to you. This 2 part set may have saved me plenty of heartache. Plus 6TB mass storage standing by for Document Mgt.
0コメント